×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Remember Display Format After Drill Down

Remember Display Format After Drill Down

Remember Display Format After Drill Down

(OP)
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?

RE: Remember Display Format After Drill Down

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'?

RE: Remember Display Format After Drill Down

(OP)
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?

RE: Remember Display Format After Drill Down

(OP)
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.

RE: Remember Display Format After Drill Down

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.

RE: Remember Display Format After Drill Down

(OP)
It worked...thank you!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close