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,

Leanne

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.

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.