I am wanting to drilldown on a subtotal. Problem is, I have two subtotals and I cannot determine which subtotal line I am on when I do the drill down. Can anyone tell me how to determine which subtotal line I am on?
Here is some simple code I put together for a test.
TABLE FILE V_TEST_FOR_FOCALPOINT SUM UNITS DESCRIPTION BY MODEL BY SERIES BY YEAR
ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET EXPANDBYROW ON ON TABLE NOTOTAL
ON TABLE SUBHEAD
"TEST FOR USERS" "" ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * TYPE=HEADING, SIZE=9, JUSTIFY=CENTER, STYLE=BOLD, $
ENDSTYLE ENDThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
September 18, 2012, 02:50 PM
Francis Mariani
I don't see any SUBTOTALs in the request (maybe they automatically occur for accordion reports)... but the syntax to styling subtotals is:
How to Identify a Grand Total, Subtotal, or Subtotal Calculation TYPE=type, [BY=sortfield] [coltype=column]
type Identifies a subtotal or total. Select from:
GRANDTOTAL which is a grand total (generated by COLUMN-TOTAL, SUBTOTAL, SUB-TOTAL, RECOMPUTE, or SUMMARIZE). See Identifying a Grand Total for an example.
SUBTOTAL which is a subtotal (generated by SUBTOTAL, SUB-TOTAL, RECOMPUTE, or SUMMARIZE). See Identifying Subtotals for an example.
RECAP which is a subtotal calculation (generated by ON sortfield RECAP or ON sortfield COMPUTE). See Identifying a Subtotal Calculation (RECAP/COMPUTE) for an example.
BY If you have a request with multiple BY fields, and two or more have subtotal commands associated with them, you can identify each field using the BY identifier. This is helpful when you want to format each subtotal differently or when you want to format only one subtotal.
You only need to include the BY identifier if you have multiple BY fields in your request.
...
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