SSRS show/hide tablix column programmatically based on parameter in rdl file

ssrs-2008 reporting-services ssrs-tablix
Pingpong picture Pingpong · Jul 25, 2011 · Viewed 15k times · Source

I have a SSRS rdl file that contains a 3-column tablix table, I want to show and show any of the columns programmatically based on the rdl paramter.

I can achieve that by setting the Hidden property of a column to an expression: 

=Parameters!ShowSecondColumn.Value

However, the problem is that when the middle column is hidden, the column space is still there. What I need is that the third column move and occupy the second column.

Any idea would be very much appreicated.

sss 2008 r2

Answer

Pingpong picture Pingpong · Jul 26, 2011

Thanks Kevin Fisher. As he pointed out, "column visibility" should be set rather than field visibility.

Related questions

SSRS How to repeat the table header on each page in print preview

I have an SSRS report, for some reason the header is not repeating on all of the pages in the print preview mode. Below is the image of the table: I have as well checked the Repeat Header rows on …

Read More
How to check if SSRS Textbox is empty

How do you check if a textbox is empty in SSRS 2008? I've tried this code and it doesn't work. IIF(ReportItems!txtCountVolunter.Value = "", false, true)

Read More
Is there an easy way to rearrange tablix columns in SSRS design mode?

I have an SSRS report which contains more than 20 columns in a tablix. Our users have decided that the data is OK, but they want the columns moved around (sigh!). It seems like it should be easy to re-arrange the …

Read More