IN Cognos report studio depends on the selection how to show list columns...

[Mahendra]

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

[Arsenal]

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?

[Mahendra]

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.