Hi ,
Could please help me how to get the prompt page of child report, when I drill through the parent report.
My requirement is like this, when I drill through the parent report, a prompt value will be passed to the child report . Before diplaying the child report, it should display a prompt page which contains all report column names to be selected by the user, to display only those columns in the child report.
Thanks,
Regards,
Venkat A.H
check this link...
http://support.cognos.com/supported/supportlink/techniques/ta_0807_03.html
Srik
Just make the column names required in child report and then do not pass those from parent report. It'll have to display prompt page when required values are not passed.
HI Suraj,
When I drill through the parent report directly child-cognos viewer is displayed without prompt page. Notice that my prompt is created on static choice in the child report.
Venkat.A.H
what suraj said above is correct. Make one prompt required and dont pass that in drill-through
Hi All,
Thanks for your reply.
I went through the link given by BISrik and got the solution.
I could get on from current requirement, but my doubt is uncleared yet.
It is a simple drill through report. In child report, a prompt is written in filter, not in 'prompt page'. So that we can pass the 'data item value ' from parent to child report.
In child report-prompt page, 'static choice' is used for 'Dynamic column selection' by creating a prompt. No other prompts are there in child prompt,except this.
Now run the report... It did not show the prompt which is created in 'child-prompt page' to select the columns dynamically.
thanks for all.
Venkat. A.H.