Focal Point
[SOLVED] SUBTOTAL Drill down on accordian report

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

September 18, 2012, 02:32 PM
huntingfootballfan
[SOLVED] SUBTOTAL Drill down on accordian report
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,
$

TYPE=SUBTOTAL,
COLUMN=UNITS,
TARGET=_blank,
FOCEXEC=unit_report (UNITS=UNITS),
$

TYPE=DATA,
COLUMN=UNITS,
TARGET=_blank,
FOCEXEC=unit_detail_rpt (UNITS=UNITS),
$


ENDSTYLE
END

This 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
September 18, 2012, 05:03 PM
huntingfootballfan
It works. Thx


WebFOCUS 7.6
Windows, All Outputs