I am having a difficult time figuring out how to pass an amper value from a summary report to a detail (drill down). Example: First report queries user for a date range and a shipper name. First report comes up with a drill down link on Destination City field. When the user clicks on that link, I want the detail report to be filtered by the date range and shipper name that the first report used.

in your style sheet, you can pass many things to the drill-down focexec. i.e.

TYPE=DATA, COLUMN=AMT, FOCEXEC=NEWFEX(ROW=ROW_NBR COL='11' EFFDATE='&EFFDATE'),$

so here we have a drill-down on the report column AMT and we will run NEWFEX when it is clicked. We will pass a report column ROW_NBR as ROW, the literal '11' as COL, and re-pass &EFFDATE as EFFDATE.

now NEWFEX can use &ROW , &COL , and &EFFDATE

hth,

drew

many thanks, Drew.