COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Mahendra on 19 Oct 2011 02:45:57 AM

Title: IN Cognos report studio depends on the selection how to show list columns...
Post by: Mahendra on 19 Oct 2011 02:45:57 AM
Hi Gurus,

In Cognos report studio depends on the selection how to show list columns?

My requirement is as below.

by using variables and value prompt we can get this.

But we have a requirement like, client will upload the column names into a table from there we have to pick the column names, and we have to show only those columns in report.


please let me know how can i get this...


Thanks in advance.
Mahi
Title: Re: IN Cognos report studio depends on the selection how to show list columns...
Post by: Arsenal on 19 Oct 2011 09:38:43 AM
if this table resides on the DB then maybe you can build a standalone query subject from this table and then build the value prompt off this query subject instead of having a static choice value prompt?
Title: Re: IN Cognos report studio depends on the selection how to show list columns...
Post by: Mahendra on 20 Oct 2011 01:52:32 AM
Hi Gurus,

Thanks for ur replay Arsenal,

As you said the Table is in DB only, but the problem is in my report requirement there is no concept of prompt page, so client is going to upload the prompt values in a Table,

how can i create a value prompt in report.