Bold specific rows in SSRS

• DaveDB

  SSCrazy

  Points: 2173

  More actions

  December 16, 2013 at 1:07 pm

  #395996

  I originally posted this last week, but my explanation could be better....

  I basically need to highlight in bold some rows in SSRS. I know that I could write an expression based on the column name, but in this case that will not help.

  Example: So lets say that the following is my report and I want to bold the rows that have John and Mike as users. How would I go about doing this? Can you bold a FULL row based on the data in a particular column? So, could I use the column "Role" and use "Sub" as the criteria?

  Any help is appreciated, and please let me know if I am explaining this correctly.

  Column Names = Role/UserName/MoneyGenerated

  Temp/Dave/$12.34

  Sub/John/$13.28

  Temp/Alex/$10.12

  Sub/Mike/$9.65

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  December 17, 2013 at 12:24 am

  #1673960

  If your data source is a database (most likely), you can add a column BoldIndicator to your query that is just a simple CASE expression:

  CASE WHEN UserName IN ('John','Mike') THEN 1 ELSE 0 END

  Then use this column in your expression on the font weight.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  December 17, 2013 at 12:36 am

  #1673964

  You can write a function in SSRS which does a string search operation on the keywords and appends the HTML by <b> and </b>

  You can use IIF expression on cells and override the Fontweight property

  Raunak J

• DaveDB

  SSCrazy

  Points: 2173

  More actions

  December 17, 2013 at 7:41 am

  #1674066

  Thanks very much!