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