Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

report with 2 picklist prompts

Status
Not open for further replies.

jjb373

MIS
Feb 4, 2005
95
US
Hello all -

I have a report which has 2 parts. A main list frame and a sub-form list frame. Since I can not pass multiple values to a sub-report from the main report I have come up with an alternate solution.

Both the main list frame and sub-form list frame have picklist prompts.
main list frame picklist prompt = ?Rep Name?
sub-report picklist prompt = ?Rep Name Sub Report?

I know you can specify a macro (cognosscript) to use on a report.

So, what I would like is to make the sub-report prompt (?Rep Name Sub Report?) use the values chosen in the main prompt (?Rep Name?).

Basically pass whatever values the user selects in the ?Rep Name? prompt to the ?Rep Name Sub Report? prompt automatically. This would eliminate the user from entering/picking anything in the second prompt.

I would greatly appreciate some code to help me acheive this. I have been on the phone with our cognos gurus and they keep telling me I can't do the report the way I want to. Well - if I can pull this macro off, then they are wrong.


-- JJB373 --
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top