One Cross tab Need to Dynamically change the JOIN

[SS07185@bcbsa.com]

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

[calson33]

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.