Suppress columns in crosstab

[dfh9630]

I have a crosstab report that I want to conditionally suppress columns based on a parameter input. For instance, the crosstab has the 12 months of the year - I want to suppress individual months based on a parameter.

 

[lbass]

This can be done, but why not just eliminate the months in the record selection formula? You could use a SQL expression {%month}:

{fn month(table.`date`)}

...and then in the record selection formula use:

{%month} <> {?months}

The problem with suppressing within the crosstab is that it is sometimes not possible to get an empty column suppressed (despite the option on the customized style tab). Anyway you could try it as follows: Go to preview mode->select inner cell and total for the month row (or column) field->right click->format field->suppress->x+2 and enter:

month(gridrowcolumnvalue("table.date")) = {?months}

This assumes that teh row or column field for month is based on a datefield. Then go to the customized style tab and select "suppress empty row" (or column).

-LB