Focal Point
Add 1 Column AFTER ACROSS and Using OVER

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9647065826

February 06, 2013, 11:47 AM
Leo Sanchez
Add 1 Column AFTER ACROSS and Using OVER
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
February 06, 2013, 01:50 PM
Francis Mariani
maybe like this example:

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
February 06, 2013, 02:19 PM
Leo Sanchez
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
February 06, 2013, 02:27 PM
Francis Mariani
Leo, are the images for each column (for SEATS 2, 4 and 5) or only one image - for a row total?


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
February 06, 2013, 02:35 PM
Leo Sanchez
One Image is for LENGTH and on Image is for WIDTH (as in your example)

Thank you SO MUCH for your help....


Developer Studio 7.6.11
Reporting Server = Unix 7.6.8
Client = Unix
February 06, 2013, 02:50 PM
Francis Mariani
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
February 06, 2013, 03:02 PM
Leo Sanchez
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