Wise Owl Answers - How do I hide columns using parameters in SSRS?

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

This video shows you three ways to allow an end user to control the visibility of columns in a report: using text boxes to toggle column visibility; using Boolean parameters to control separate columns; and using a multi-value drop list parameter to control all columns with one parameter.

Chapters
00:00 The Question
01:46 The Basic Report
02:26 Choosing to Retain or Remove Column Space
04:44 Hiding a Single Column with a Text Box
07:38 Hiding Multiple Columns with a Text Box
08:53 Creating a Boolean Parameter
10:22 Setting the Hidden Property with an Expression
11:33 Controlling Multiple Columns with One Boolean Parameter
13:04 Creating a Multi Value Drop List
15:49 Checking if an Item is Selected
18:54 Converting the Index to a Boolean Value
20:27 Adding the Expression to the Hidden Property

[bujin]

I've been using SSRS for years, but have never considered using a textbox to toggle column visibility before. That might come in very handy.

[FlyingColors]

Is SSRS still being worth learning, is in Use in current IT companies?

[hunnydarling]

Dear Sir, please help, how to convert month into roman format, January = I, February= II, May = V, etc