CODEWITHSUNDEEP
sql-serverreporting-services
user3014966
user3014966

Reputation: 263

Hide some columns which are generated dynamically using ssrs

I have created a matrix which contains a group column header which is generated automatically and always gives as result : july,Aug,Sep,Oct,Nov...June.

My purpose is how can i modify visibility to get the following result : when the user chooses , for example , Sep : it will only be visible july,Aug,Sep , because the actual for the other months is null .

I can't access to each column individually and makes modification in visibility I tried 

=iif(Fields!actual is nothing , false , true )

and 

=iif(Fields!actual.IsMissing , false , true )

but it didn't worked for me

Upvotes: 0

Views: 78

Answers (1)

Kiril Rusev
Kiril Rusev

Reputation: 753

I suppose that the user is able to specify the month, isnt he? Therefore, you can add a where clause in your query

where tbl.date_col <= @month_parameter

EDIT: The user has applied a visibility expression on the group, instead of doing that over the Textbox

Upvotes: 1

Related Questions