Remember Display Format After Drill Down 1

[kvang]

I want to create a report where the user can select the display format (Excel 2000 or HTML) and have the report remember what the user selected after he/she drills down to the second report. The 2 drill-down reports will be created in a procedure file. The user will make their selection and run the report from html file. How can I make the reports remember what the user selected before they click a run button?

 

[focwizard]

In a drill-down, what you 'click' on is normally passed as a variable to the called procedure. What else do you mean by 'remember what the user selcted'?

 

[kvang]

The user will make their criteria selection on the HTML page, e.g. FromDate, ToDate, Display Output (HTML, PDF, Excel 2000, etc.). Then the user will click on a RUN button to generate the report. Say for example, the user selects Excel 2000 as output and clicks the RUN button. A report is displayed. The displayed report gives the user a drill-down capability in one of its columns. When the user clicks on the column to drill down, how can I pass the selected display output to the second report?

 

[kvang]

What is happening now is that the user has to select the display output a second time when he/she drills down to the second report. I want to skip that part and just go straight to the second report.

 

[focwizard]

You should be able to pass the value of your output type as an additional parameter to the called FEX that does the drill-down. When you pass a parameter, you can pass an AMPER variable to the called procedure by enclosing the amper variable (in your case, the format) in single quotes. It might look like:

FOCEXEC=fexname(REPT_TYPE='&OUTPUTTYPE')

where &OUTPUTTYPE is the name of the variable containing the selected display output.

 

[kvang]

It worked...thank you!