Bold specific rows in SSRS

  • 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

  • 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

  • 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

  • Thanks very much!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply