December 16, 2013 at 1:07 pm
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
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
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
Thanks very much!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy