Focal Point
[CLOSED] Drill-downs

This topic can be found at:

February 14, 2020, 09:38 AM
Leanne Wood
[CLOSED] Drill-downs
Good morning-
I'm trying to create a drill-down report and having trouble. I am able to successfully create the drill-down, where one reports drills down to the next, but it drills down to the entire document instead of the target field. I'm not sure what I'm missing.

Can someone help with this?
thank you in advance
Leanne Wood

This message has been edited. Last edited by: FP Mod Chuck,

WebFOCUS 8.2.02M, App Studio 8.2.02M
Windows 2012 Server, Excel
February 14, 2020, 10:11 AM
FP Mod Chuck

Without seeing your code I suspect you are missing a WHERE statement on the field value you are drilling down on in the drill down report.

Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 14, 2020, 12:51 PM
Make sure you have COLUMN= syntax in your drilldown like below:
TYPE=DATA, COLUMN=COUNTRY, ALT='Chart 1', TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/sandbox/chart_1.fex(COUNTRY=CAR.ORIGIN.COUNTRY), $

This code assumes the report you're drilling into has a WHERE COUNTRY EQ &COUNTRY; in it.

If you don't put COLUMN=COUNTRY in your drill down, all columns in your report will be drillable.

WebFOCUS 8206, Unix, Windows