How to hide columns in ssrs report builder based on startdate and enddate parameters?

Question

I am new to SSRS. I have created a report with the following format.

I want to hide months columns based on startdate and enddate parameters. How can I achieve this? Suppose user selects date from July to Aug then Jun2014 should be hidden.

Any Ideas? Please.

Answer 1

Assuming that your tablix is of the matrix variant, then the easiest way would be to ensure that your dataset doesn't contain any data outside the date range the user has selected. If its not then definitely read up about matrix style reports and convert it!