Hide specific columns in crosstab (PDF)

Hi,
 
I have a crosstab with several columns created dynamically from a dimension. I want to hide two of these columns/cells based on specific values. It's easy to hide the columns in html view, but in PDF there's always a 'placeholder' where the columns would be - the cells are not there but they show as empty space.
 
Is it possible to hide the columns completely in PDF? I've looked at different scripting phases and using DE API but I can't seem to get it working properly.
 
Thanks,
Arto

Find more posts tagged with

Comments

Chad Montgomery

I haven't checked myself if what you're trying to do is possible. But you could go about it another way by having two crosstabs, one with the columns and one without. Then you'd hide the one without the columns for all but PDF output, and hide the one with the columns for only PDF output.

ArK

Hi, 
 
Thanks for your reply!
 
I already have a few crosstabs and some of the data in them is hidden. The problem is that the data I'm having problems with comes from a single database table/data set/dimension and all of this data needs to be shown in aggregations so I can't filter it out. I'm not sure if I can "divide" this dimension in any way?
In the other crosstabs I have simply set the visibility properties of certain cells to none in designer so they will be hidden in every format, but if i do this in the crosstab I'm having issues with the columns I want to be shown would also be hidden.

ArK