Focal Point
Drilldown On Subtotal Title
January 22, 2008, 06:16 AM
focuzsambitDrilldown On Subtotal Title
How to provide drilldown on Subtotal-Title ??
I want drilldown at "Total Country" level.
Look at the below code(simple one)..i tried providing drilldown based on column value...but not working.
TYPE=SUBTOTAL,BY=1,COLUMN=N1/N2... none working.
But if you change it to N3, its creating hyperlink on RETAIL_COST succesfully.....
TABLE FILE CAR
PRINT
RETAIL_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,BORDER=LIGHT,FONT='VERDANA',SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=SUBTOTAL,BY=1,COLUMN=N1,TARGET='_blank',FOCEXEC=sm2,$
ENDSTYLE
END
WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI
January 22, 2008, 10:43 AM
Francis MarianiStumped, I am!
I tried setting it up with the dreaded GUI, but, no dice!
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
January 22, 2008, 12:11 PM
Alan BI got this to work:
TABLE FILE CAR
PRINT
RETAIL_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,BORDER=LIGHT,FONT='VERDANA',SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=SUBTOTAL,BY=B1,TARGET='_blank',FOCEXEC=sm2,$
ENDSTYLE
END
Though the country and value have a link.
Alan.
WF 7.705/8.007
January 22, 2008, 12:29 PM
Francis Marianiquote:
Though the country and value have a link.
- there's the rub.
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
January 22, 2008, 12:33 PM
Francis MarianiIf you're willing to do it, this will work:
Set up the drilldown for the whole Subtotal line, then set focexec=none for each of the columns in the subtotal, except the first one...
TABLE FILE CAR
PRINT
RETAIL_COST
DEALER_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,BORDER=LIGHT,FONT='VERDANA',SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=SUBTOTAL, BY=COUNTRY, TARGET='_BLANK',FOCEXEC=SM2,$
TYPE=SUBTOTAL, BY=COUNTRY, COLUMN=RETAIL_COST, FOCEXEC=NONE, $
TYPE=SUBTOTAL, BY=COUNTRY, COLUMN=DEALER_COST, FOCEXEC=NONE, $
ENDSTYLE
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
January 22, 2008, 11:11 PM
focuzsambitu rock !!!!!!!!
WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI