passing prompt values from main query to sub query

[xyzzyx]

Hi
Can anyone tell me how to pass parameters from the main query to subquery.I mean from one list frame to another.

Actually, I have the multi select prompt in the main query.I have selected two values when its prompted. Now I want these two values to be available in the subquery. As my subquery is also using the same prompt values.

Thanks in advance
Chandra

 

[griffindm]

Make a main query calculated column equal to the prompt and it will be available to the sub-query.

 

[ADB1]

Firstly, select the column you wish to be promtped on within the sub report, hide it and then create a filter in the sub report as follows:

T1.ColumnA = 'Main Query.ColumnA'

Cheers.

 

[SoumyaKrishnan]

Hi xyzzyx,

If MainQueryColumnXYZ = MainQueryPrompt is what you have in your main query filter then try putting -

SubQueryColumn = 'Main Query.ColumnXYZ' into your SubReport.

Try the Impromptu Documentation, I remember reading something like this there.

Soumya.

 

[xyzzyx]

Hi griffindm
I tried with the calculated column created in the main query
Then I just equated it to the promptu value. As the prompt is multiselect prompt I selected 2 values,let us say x,y.
Now as u said the calculated column is available in the subquery.But the calcualted column is having only one value ie.y. But I want both x,y to be available in subquery
Can you give me some other idea.

Thanks a lot for ur effort.