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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
I’m looking for help on how to get a column name on an across report. I’ve not done very many of these and haven’t been able to figure it out or find any other posts that would solve what I am trying to do. I have a lot of different types of data coming in based on dates. I want to print a row of data for each metric. That row will contain the data for that metric along with many columns per date. For example, this is what I want:
Metrics 01/15/2016 01/31/2016 02/01/2016 02/15/2016 Member Count 130 135 142 140 Total Assets 15000.00 15500.00 15800.00 15900.00 Average Age 45 48 44 50
I’m building out my report and can get everything I want except the heading of the word Metrics above my metric fields. My report is built like this: TABLE FILE HOLD001 SUM HOLD001.HOLD001.MBR_CNT AS 'Participant Count' OVER HOLD001.HOLD001.TOT_AV_AMT AS 'Total Assets' OVER HOLD001.HOLD001.AVG_MBR_AGE AS 'Average Age' OVER ACROSS LOWEST HOLD001.HOLD001.DisplayDate AS '' ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/WFC/Repository/RIS/FSA_Participant_Overview/stylesheets/plain_report.sty, $ ENDSTYLE END
How can I get the word ‘Metrics’ to print on the left side of the across row?This message has been edited. Last edited by: <Emily McAllister>,
The ACROSSTITLE parameter enables you to display both the ACROSS title and the ACROSS values on one line, you can issue the SET ACROSSTITLE = SIDE command. This command places ACROSS titles to the left of the ACROSS values. The titles are right justified in the space above the BY field titles. The heading line that is created by default to display the ACROSS title will not be generated.
As it will be right justified you need to add styling to make it left justified, something like: TYPE=ACROSSTITLE, JUSTIFY=LEFT, $
WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
This will get you closer, but still not what you would like. OVER complicates report design. Since there is no BY statement, there's no place to put the ACROSS column title. In the example below, I create a dummy BY column so that the ACROSS column title is placed to the left of the ACROSS values, but the layout isn't pretty.
DEFINE FILE GGSALES
TABLE FILE GGSALES
BY DUMMY1 AS ''
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
Thank you Daniel! Francis is right, it does work beautifully.
I had ran your example but didn't see that the across field and the first sum were the same pieces of data. I applied this same technique to my report and am getting exactly what I wanted. Thank you very much!