how to get the prompt page of child report in drill through.

[arroju_venkat]

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

[BIsrik]

check this link...

http://support.cognos.com/supported/supportlink/techniques/ta_0807_03.html

Srik

[Suraj]

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.

[arroju_venkat]

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

[jahnavi]

what suraj said above is correct. Make one prompt required and dont pass that in drill-through

[arroju_venkat]

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.