Post reply

Bold specific rows in SSRS

  • 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

  • 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

  • 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

  • December 17, 2013 at 7:41 am

    #1674066

    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