Hiding Certain Crosstab Columns in Report Author 10.2.1

[gosoccer]

Hi everyone, :)

I have a Crosstab with different Interseetions. I'm trying to hide certain intersections columns to not to display based on the user's parameters selections.

So, as the attachment shows, I have a drop down box with Marriages and Diverse selections.

So, I'm trying to show only Marriages, when the user selects Marriages.

If you could help, I would greatly appreciate it.

Thx so much.

[Francis aka khayman]

use conditional blocks. you need to create several crosstabs depending on how many kinds of display should be available.

you can use render variable as well but hiding a column may mess up your display and would require some fixing to do

[gosoccer]

Thx so much. I'm using a combination of Conditional Style and Style Variable to use the No Box feature/option under the Advanced Conditional Style setting. It's working great but I'm not done yet.

For Style Variable, I'm using a sentence such as below to deal with each Intersection/Column since I have multiple Intersections for each Columns.

if (ParamValue('whatever_param') in ('1')) then
('Y')
else
('N')

You are correct, it can get really messy.

Thx  :)

[gosoccer]

Do you by any chance any quick instruction in using conditional blocks? The Crosstab has 7 columns. So would I create 7 Crosstabs and Embbed them into 7 Conditional Blocks.

My apologies for bothering you with this issue. I'm desperate. I spent 12 hours so far and I'm not getting anywhere.

I'm familiar with setting up Blocks and establishing Rendering Variables to show an entire Block or not to show an entire block
based on a if and else like below.

Is the above what you are suggesting? 7 different blocks?

thanks so much for your time.

[gosoccer]

Ok, I got it working: ParamDisplayValue('car_param') CONTAINS ('CAR-1')  in Conditional Style. Thx and Happy New Year