COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ghostraider on 29 Jul 2008 02:53:01 PM

Title: Subquery In Report Studio
Post by: ghostraider on 29 Jul 2008 02:53:01 PM
Hi All,

In Impromptu we could use sub queries, for example a report within a report. I have a table which has only one column (names of people) and it has 10 rows of data. I have several reports where i filter data using 3 people from the column and i use the same 3 people's names to filter out data in many reports. How can i just have these 3 names pre-selected in a report and use it in all the others instead of creating a prompt each time or entering the values in the filter. Please let me know.

Thanks.
Title: Re: Subquery In Report Studio
Post by: rockytopmark on 30 Jul 2008 04:22:15 PM
Master/Detail Relationship