COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: fasi on 27 Dec 2006 10:26:19 AM

Title: Dynamic Columns from prompt values
Post by: fasi on 27 Dec 2006 10:26:19 AM
Hi Folks,

In Crosstab I want to see rows as colums that has to change dynamically based on the prompt values that is going to select by the user

If any one has faced this issue please suggest me

Thanks
Fasi
Title: Re: Dynamic Columns from prompt values
Post by: sir_jeroen on 28 Dec 2006 06:57:48 PM
Take a look at my example I posted earlier on this forum (maybe it's in the Reportnet section). You can use a #prompt('param','token','[query item]')# expression. This works great and doesn't require any complex case statements. Just put in the Full Syntax for a query item e.g. [namespace].[query subject].[query item].
Title: Re: Dynamic Columns from prompt values
Post by: fasi on 29 Dec 2006 01:29:12 PM
Thanks for your replay,i'm trying to find in reportnet form but no luck,

Can you please send me the link.

Thanks & regards,
Fasi.