Using same Prompt in sub-reports - Impromptu

[Nirs0278]

I am attempting to build a report

In the main query I have prompted the user to enter the dates for the beginning and ending period and used this information within my filter.
Ex) claim_effective_date between ?begin? and ?end?

Now in the sub-reports i am attempting to refer to the same prompts and same info from the main query...
Ex) claim_effective_date between ?Main Query.begin? and ?Main Query.end?

However, i am unable to locate these same prompts i built previously within the available components box and cannot figure out how to insert this expression anyway i try... I do not want to build 10 separate prompts asking the same questions...

I know this can be done, what am i missing?

 

[DoubleD]

Your two prompts need to be fields in your main report. It is not necessary to display them, but they must exist on the Data tab to be referenced from the sub-queries.

I am what I am based on the decisions I have made.

DoubleD

 

[griffindm]

To elaborate on what DoubleD said, you need to create calculated columns in the main value that contain just the prompt value. They then become visible as Main Query data items in the sub report.

Regards,

Dave Griffin




The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[Nirs0278]

thanks a lot to both of you..

ur posts were extremely helpful