Reputation:
In MS Reports I need to hide the columns in the tablix, but I need to keep the tablix width as it was. By default, if I hide the columns in the tablix it will automatically reduce the width.
I also need to increase some other columns width when I hide the columns.
I will add some Screenshot here.
This is the Original report.
So I need to hide all columns that has the value zero. So I did it and I got the result as
So now I want to keep the tablix width as it was in the original report by adding space (increase the width ) of the "Design NO" column (2nd Column) .
Pls help me , Thank you..!!
Upvotes: 3
Views: 1644
Reputation: 7218
The only way to hold the tablix width is to have something occupy the space. I suggest using conditional formatting to use a white font. If you don't have data for that cell, use an expression that checks if the field that is normally there is empty and return a constant value that gives you the width you need. If you need to increase the width of other columns, you're going to have to add embedded spaces or something. The dynamic sizing of columns depends on having something occupy the space, even if it's spaces or white text.
Upvotes: 1