SQL: Hide Column Based On Parameter

This is how you can hide columns in table based on parameter. This is from an article of SQL Reporting Services With Dynamic Column Reports from codeproject.com. The specific tutorial can be seen in step 10 of that article. Code example. Modified on your own accord.

SQL: Case In IF Statement

This is how you use case expression in if statement.