 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| blanc line in subfoot | Login/Join |
| Virtuoso |
To make a report better readable I would like to add a blanc line under the subtotal ONLY when there is a subtotal. I tried something like ON CLTNR_REF SUBTOTAL MULTILINES AS 'subtotaal' ON CLTNR_REF SUBFOOT " " WHEN &LINES GT 1; But this won't work.... Suggestions?
| ||||||
|
| Virtuoso |
Hello Frank, MULTILINES works with most ON operations. Try the following: ON CLTNR_REF SUBTOTAL MULTILINES AS 'subtotal' ON CLTNR_REF SUBFOOT MULTILINES " " Regards, Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Expert |
{CODE]TABLE FILE CAR COUNT MODEL NOPRINT BY COUNTRY SUM SALES BY COUNTRY BY MODEL ON COUNTRY SUBTOTAL MULTILINES ON COUNTRY SUBFOOT " " WHEN C1 GT 1 END[/CODE]In my example, see FRANCE - no blank line. But, in my opinion, this doesn't make the report easier to read... Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
Daniel, that's a new one for me! Thanks! TABLE FILE CAR SUM SALES BY COUNTRY BY MODEL ON COUNTRY SUBTOTAL MULTILINES ON COUNTRY SUBFOOT MULTILINES " " END Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Virtuoso |
Thanks Danny that is great.... thanks Francis....you are right, it remains unreadable and makes it in fact even more confusing.... I have got questions from the end users and thought this would help...It does not.
| |||||||
|
| Virtuoso |
but the MULTILINES does not work a subhead... thanks anyway.
| |||||||
|
| Expert |
Look for "Creating a Sort Heading or Footing" in the documentation. No MULTILINES for SUBHEAD - probably because FOCUS doesn't know how many lines yet when creating the SUBHEAD. Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Virtuoso |
Frank and Francis, Try this: TABLE FILE CAR SUM SALES BY COUNTRY BY CAR ON COUNTRY SUBTOTAL MULTILINES ON COUNTRY SUBFOOT MULTILINES " " END See what happens after FRANCE Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Virtuoso |
So if there are no Sales...it does nothing..interesting.
| |||||
|
| Expert |
Prarie, I think you will find that the reason is no multiline break occurs for FRANCE, not the fact there are no sales. T
| |||||||||
|
| Virtuoso |
Correct Tony. Just add in RCOST and DCOST and the results will be the same. Alan. WF 7.705/8.007 | |||
|
| Virtuoso |
oh...I see. Well that is not useful.
| |||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |