How can I set up an SSRS table that will allow me to hide columns (in grouped columns) and toggle visibility? Can I eliminate the whitespace due to hidden columns?

How can I set up an SSRS table that will allow me to hide columns and toggle visibility? Can I eliminate the whitespace due to hidden columns?

Hi there Can you please explain further what you are trying to achieve. I mean I would like to know when you would like to hide the column and when would you like to display the column(Conditions). Is it depends on the parameter values? Please give some details Many thanks Syed Qazafi Anjum

Hi InAhc, Generally, we can select Show or hide based on an expression to use an expression evaluated at run time to determine the visibility. Please refer to the article about hiding an item: http://technet.microsoft.com/en-us/library/ms159830(v=sql.100).aspx Otherwise, we can also hide and show report items by adding drilldown. For more information, please see: http://technet.microsoft.com/en-us/library/ms156456(v=sql.100).aspx Im confused with eliminate the whitespace due to hidden columns in your case. For further investigation, please elaborate your issue with more details Regards, Bin LongBin Long TechNet Community Support