Print Page - One Cross tab Need to Dynamically change the JOIN

Title: One Cross tab Need to Dynamically change the JOIN
Post by: SS07185@bcbsa.com on 19 Sep 2013 01:42:42 PM

Gurus-

I have a parameter with two choices. I also have one crosstab table. This is very tricky but when a user selects OPTION A in the prompt i want the cross tab to display Query A with an equal join 1:1...if the user picks OPTION B i want the cross tab to display Query A with an outer join 0:n.

Is this possible? Is there another creative way to get this result I want?

Any help would be appreciated

Title: Re: One Cross tab Need to Dynamically change the JOIN
Post by: calson33 on 19 Sep 2013 01:51:44 PM

Create two cross tabs, one for each situation, and put them in conditional blocks.

Make the first block show when OPTION A is selected, and the second one show when OPTION B is selected.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: SS07185@bcbsa.com on 19 Sep 2013 01:42:42 PM