COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 18 Dec 2008 02:27:25 PM

Title: cross tabs should move based on user selection
Post by: jd on 18 Dec 2008 02:27:25 PM
Hi,
I have 3 cross tabs in my report. my problem is based on user selection cross tabs should move back and forth. is it possiable.

thanks.
Title: Re: cross tabs should move based on user selection
Post by: Suraj on 19 Dec 2008 10:13:14 AM
You can do this by using conditional block.
Since you have only 3 crosstabs, you can have all 3 in different order in each block and render one per user's choice.
Title: Re: cross tabs should move based on user selection
Post by: jd on 22 Dec 2008 01:57:14 PM
Can you Explain it little clear
Title: Re: cross tabs should move based on user selection
Post by: Suraj on 22 Dec 2008 02:16:33 PM
You can have a conditional block with each block containing three crosstabs in different order.

For example, block variable 1 can have Fall08, Spring09 and Summer09;

block variable 2 can have Spring09, Summer09 and Fall08;

block variable 3 can have Summer09, Fall08 and Spring09 ; etc...


Now, you have to make the conditional variable that corresponds to user selection.

Also, how are users making the selection?
Do you have just one prompt or multiple prompts?
Title: Re: cross tabs should move based on user selection
Post by: jd on 23 Dec 2008 10:43:15 AM
how should I create conditional variable?
Title: Re: cross tabs should move based on user selection
Post by: Suraj on 23 Dec 2008 12:45:55 PM
That depends upon how you are getting parameters from users when they select prompt.