Hello,
I have a crosstab report with three columns, but one can not be displayed in the layout, how do I hide it?
Have tried using the crop feature, but it has a filter that works only if this column is displayed in the layout, but the user does not want to see this column.
I appreciate if you help me!
I've found that "hiding" columns in a crosstab can be tricky based on layout and business requirements...
If you can't simply set Box Type = None for the column (and its header)
Note: Depending upon your layout, this can sometimes cause problems with the alignment of the remaining displayed columns.
Then, try setting the column width of the column you wish to hide to be 0.
Note: You may need to set the table properties of the crosstab to Fixed Size.
Hope this helps.
Thanks,
Adam.
I agree with adam that hiding in a crosstab can be difficult, but if you put the column rightmost in the crosstab you can often set box type to none without affecting the rest of the layout
It worked, thank you!