Focal Point
[SOLVED] Drill down to different report based on selection of the drill down field

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

July 09, 2015, 02:15 PM
WebFocusDiver
[SOLVED] Drill down to different report based on selection of the drill down field
Does anyone know how to do this?

I create a report and want to drill down to other reports or charts based on the value of my selection. For example, the drill down field A has values of 1,2,3,and 4. So if I right click 1 in my report, I want to drill down to another report B. If i right click value of 2 in my report, I want to drill down to report C instead of B.

Thanks
Jacky

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8.1.05
Windows, All Outputs
July 09, 2015, 02:32 PM
Danny-SRL
Diver,
Drill to report "Q" with the value clicked.
In Q, according to the value:
1 then EX B
2 then EX C

You can also use -INCLUDE instead of EX.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

July 09, 2015, 03:02 PM
Francis Mariani
In the stylesheet, use the WHEN statement for the drilldown - something like:
TYPE=DATA, COLUMN=A, WHEN= A EQ '1',
  FOCEXEC=IBFS:/WFC/Repository/DomainFolder/ReportFolder/report_1.fex \
  PARM_A=A \
  ), $
TYPE=DATA, COLUMN=A, WHEN= A EQ '2',
  FOCEXEC=IBFS:/WFC/Repository/DomainFolder/ReportFolder/report_2.fex \
  PARM_A=A \
  ), $
...



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
July 09, 2015, 05:05 PM
WebFocusDiver
Thank you Francis. It seems I am getting close. I change the stylesheet with when statement, it gives me the error say "Keyword has illegal value when= N2 EQ 'XXX' OR 'XXXX'. Any suggestion? Thanks


WebFOCUS 8.1.05
Windows, All Outputs
July 10, 2015, 04:35 AM
Martin vK
WHEN in the stylesheet works only with simple expressions like WHEN = A EQ 1, or WHEN = X LT 'ABC'. But is does not accept expressions with OR or AND.

So make an extra DEFINE:
TEST_N2/I1 = IF N2 EQ 'XXX' OR 'XXXX' THEN 1 ELSE 0;

and use WHEN = TEST_N2 EQ 1

Do not forget to add TEST_N2 NOPRINT to your TABLE request, otherwise the value is not known.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
July 10, 2015, 11:15 AM
RSquared
have you tried using the multi drilldown feature?


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
July 10, 2015, 11:18 AM
George Patton
I like Danny's solution much better. "Simple, yet effective"

In fact the various drill-down reports can all be in the same fex if you use labels and a GOTO statement.


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
July 10, 2015, 02:38 PM
RSquared
Now that you mention it, so do I.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit