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.
My code is like this: TABLE FILE CTGRY1 SUM QTY AS '' OVER PERCENTS AS '' BY CTGRYID NOPRINT BY CTGRY_DESC AS 'Category' BY TARGET AS 'Target' ACROSS RPT_MONTH AS '' END
I need to add 2 Fields which are ALPHA values to represent an ALPHA IMAGE OF a light indicator for the QTY and the PERCENTS.
I am using 7.6.4
Developer Studio 7.6.11 Reporting Server = Unix 7.6.8 Client = Unix
Posts: 29 | Location: Houston | Registered: June 19, 2012
TABLE FILE CAR
SUM
LENGTH AS ''
COMPUTE L_IMG/A100 = '<img src="/approot/common/images/alert.png" />'; AS ''
OVER
WIDTH AS ''
COMPUTE W_IMG/A100 = '<img src="/approot/common/images/magnify-glass.png" />'; AS ''
BY COUNTRY NOPRINT
BY CAR AS 'CATEGORY'
BY MODEL AS 'TARGET'
ACROSS SEATS AS ''
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
Francis, that is ALMOST PERFECT.... I apologize for not mentioning this, but I need the images to appear after my LAST ACROSS....so like in your example, I need the images after the 5....
Thank you
Developer Studio 7.6.11 Reporting Server = Unix 7.6.8 Client = Unix
Posts: 29 | Location: Houston | Registered: June 19, 2012
Does that mean you want multiple images at the end of the row? Because you could have multiple measures per row (in my example I only have one pair of measures per row, but there could be measures for 4 and 5 seater TR7...).
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
No, I need one image on the first row and another image on the second row, but at the end of the ACROSS.
I just found a "work around"....I've converted the numeric columns to ALPHA and made both files (the numeric file and the images file) the same format/size, so I used a USE command and VOILA....see below...
TABLE FILE CTGRY1 SUM COMPUTE ALPHA_QTY/A80 = FTOA(QTY, '(D12.2C)', ALPHA_QTY); AS QTY2 COMPUTE ALPHA_PCT/A80 = FTOA(PERCENTS, '(D12.2%)', ALPHA_PCT); AS PCT2 BY CTGRYID BY CTGRY_DESC BY TARGET BY RPT_MONTH ON TABLE HOLD AS NEWCTGR FORMAT FOCUS END -RUN TABLE FILE NEWCTGR SUM QTY2 PCT2 BY CTGRYID BY CTGRY_DESC BY TARGET BY RPT_MONTH ON TABLE HOLD AS NEWCTGRY FORMAT FOCUS END -RUN -*?FF NEWCTGRY TABLE FILE CTGRYTRND SUM TREND_ARROW AS QTY2 TREND_BALLS AS PCT2 BY CTGRYID BY CTGRY_DESC BY TARGET BY RPT_MONTH ON TABLE HOLD AS NEWTRND FORMAT FOCUS END USE NEWCTGRY AS NEWCTGRY NEWTRND AS NEWCTGRY END -* TABLE FILE NEWCTGRY SUM QTY2 AS '' OVER PCT2 AS '' BY CTGRYID NOPRINT BY CTGRY_DESC AS 'Category' BY TARGET AS 'Target' ACROSS RPT_MONTH AS '' END
Thanks again for all your help... I appreciate it!
Developer Studio 7.6.11 Reporting Server = Unix 7.6.8 Client = Unix
Posts: 29 | Location: Houston | Registered: June 19, 2012