Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]FML and Excel templates

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]FML and Excel templates
 Login/Join
 
Geoff Fish
Platinum Member
posted
Has anyone ever used an FML report to create a template for an excel report? I know this is an odd question but I am in the middle of creating an elaborate excel report and before I finish accumulating all the data for the report I am trying to decide how my template will facilitate this.

Oh and the reason i need to use a template is because their will be charts on the second sheet driven by data on the first sheet.

Thanks for any advice in advance.

This message has been edited. Last edited by: <Emily McAllister>,


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Tamra
Guru
posted Hide Post
Geoff,

Just a thought regarding FML. You can POST data using FML and then PICK it up in another procedure ( or the same procedure). Possibly, you can POST the data to a file and use it somehow in Excel.

Using the POST Command in an FML Request

Using Excel Templates

Creating Excel 2007/2010 Worksheets Using Templates
Question - Why use FML though is it due to the FML functionality that you need?

Thank you for participating in the Focal Point Forum.

Kind Regards,
Tamra Colangelo
IBI Focal Point Moderator

This message has been edited. Last edited by: Tamra,


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Geoff Fish
Platinum Member
posted Hide Post
Thanks Tamra especially for the links


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Geoff Fish
Platinum Member
posted Hide Post
quote:
Originally posted by Tamra:
Geoff,

Just a thought regarding FML. You can POST data using FML and then PICK it up in another procedure ( or the same procedure). Possibly, you can POST the data to a file and use it somehow in Excel.

Question - Why use FML though is it due to the FML functionality that you need?

Thank you for participating in the Focal Point Forum.

Kind Regards,
Tamra Colangelo
IBI Focal Point Moderator



I may not need FML formatting if can get the template to work but FML allows me to to put different results on the same page as rows


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]FML and Excel templates

Copyright © 1996-2020 Information Builders