COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: snoozer309 on 23 Apr 2007 11:14:04 AM

Title: Cascading prompt question
Post by: snoozer309 on 23 Apr 2007 11:14:04 AM
I have a report that uses report picklists for a series of cascading prompts (area, region, site).  I would like to insert a prompt variable to display in the main report's header.  The prompt variable is for one of the subreports though.  Is there a way to do this? 

Thanks,
Laura
Title: Re: Cascading prompt question
Post by: cognosfreelancer on 24 Apr 2007 01:21:16 PM
Hi Lara

Here is one way you can do it.

Put the main report and all sub reports in one form frame.

Select the list frame containing the sub report with your prompt variable.

Next from the insert menu select 'Insert Prompt Variables'.

select the desired prompt and locate mouse pointer in the main report header.

This works I tried it out myself

NKT