Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bold specific rows in SSRS Expand / Collapse
Author
Message
Posted Monday, December 16, 2013 1:07 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, Visits: 215
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
Post #1523409
Posted Tuesday, December 17, 2013 12:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:37 AM
Points: 13,638, Visits: 10,524
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1523548
Posted Tuesday, December 17, 2013 12:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
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


Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1523552
Posted Tuesday, December 17, 2013 7:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 24, 2014 11:06 AM
Points: 109, Visits: 215
Thanks very much!
Post #1523689
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse