CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2012
Salman
Salman

Reputation: 1

SQL Server Report Services (SSRS), Access The properties of a Tablix from its Expresssion Builder

While Using SQL Server Report Services (SSRS), I wanted to access the properties of a Tablix from its Expresssion Builder. My Issue, Three are Three Tablix on the Page. I want to dynamically change the visibility of each tablix based of a parameter I pass to the report. e.g. I am passing the Parameter @ShowTablix with the value "Tablix1" I expect Tablix1 to be visible while Tablix2 & Tablix3 are invisible.

Now i know a way how to do this. In The Visibility.Hidden Property for the
Tablix I am setting the expression

=(Parameters!ShowTablix.Value<>"Tablix1")

I have to do this for each tablix so it becomes for Tablix2

=(Parameters!ShowTablix.Value<>"Tablix2")

and for Tablix3

=(Parameters!ShowTablix.Value<>"Tablix2")

But I want to use something like this

=(Parameters!ShowTablix.Value<>Me.Name)

i.e. a generic expression i can apply to all my tablixes as is . any ideas?

by the way ReportItems...=ReportItems("Textbox1").Value is only useful for textboxes

Upvotes: 0

Views: 670

Answers (1)

Pintu Kawar
Pintu Kawar

Reputation: 2156

You can change the name of the Tablix1 from the Property itself.

Right click and go to tablix properties and than change the Name. Or it can be done from the Properties Window.

Upvotes: 0

Related Questions