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.
Hi All, I have a FML report with RECAP calculations and it has a LABEL called "SUBTTL". Is there a way to pass the FML LABEL in the drill function as I need to do a drilldown for this report. Any suggestions would be appreciated...
Regards, MSAMThis message has been edited. Last edited by: Kerry,
When Drilldown is performed on an FML Report, LABELS are never used in the Drilldown. Only the actual values that you actually define in the Drilldown (Parameters).
The FMLFOR might be able to handle some of your requirements as Dan has mentioned. I don't think it will handle a RECAP as you might need. It would help to know the exact requirements.
Below is documentation on how the FMLFOR works along with other FML functions:
Syntax: How to Retain FOR Values in a Request Note: these commands are allowable only as a compute and do not appear in the drop down list of functions
FMLFOR(‘Ann’) Returns the FOR value associated with each row in an report. If the row was generated as a sum of data records using the OR phrase, FMLFOR will only return the first FOR value specified in the list of values. If the OR phrase was generated by an Hierarchy ADD command, FMLFOR returns the FOR value associated with the parent specified in the ADD command the FOR value associated with each row in an report
FMLCAP (‘Ann’) Returns the CAPTION value associated with each row in an report
FMLLIST (‘Ann’) Returns the FOR statement associated with each row in an report. Appropriate If the row was generated as a sum of data records using the OR phrase.
Ann Alphanumeric Is the length of the field that contains the result, or the format of the output value enclosed in single quotation marks. FMLLIST may be up to 4095 bytes.
Posts: 229 | Location: New York | Registered: July 27, 2004