Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Highlighting a row once a parameter has been selected in SSRS Expand / Collapse
Posted Friday, April 26, 2013 5:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 7, 2013 3:30 AM
Points: 62, Visits: 155
I have a report that has 3 parameters, RaceDate, RaceCourse, SilksColours but the SilksColours parameter is optional, but if the SilksColours is selected I just want to highlight the row in my report with the colour yellow but all the other rows stay white.

Is this possible?


Post #1446907
Posted Monday, April 29, 2013 4:36 PM


Group: General Forum Members
Last Login: Thursday, July 21, 2016 9:25 AM
Points: 176, Visits: 543
It is not possible to assign formatting to an entire row with a single property. However, you can select all the text boxes that make up the row and then use the Property pane to edit the BackgroundColor property of all of them at once. You would choose the "Expression" option and then enter an expression such as the following:

= If(Parameters!SilksColours.Value = Fields!SilksColours.Value, "Yellow", "White")

That code assumes the name of the dataset field is the same as the name of the parameter. If not, adjust as appropriate.

Post #1447810
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse