February 4, 2014 at 1:20 pm
Hi,
I have a requirement to conditionally format cell (not row) backgroup colors using SSRS expressions (not custom code) based on the following:
IF arrival_date IS NULL and we are 8 weeks from sys_install_date highlight the arrival_date NULL cell YELLOW and if arrival_date IS NULL and we are 6 weeks from sys_install_date highlight the arrival_date NULL cell RED.
Thank you for your assistance.
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
February 4, 2014 at 3:28 pm
Dealing with NULL values can be tricky in SSRS, depending on the source.
What is the source? SQL Server , SSAS?
Normally I don't calculate conditional formatting, but when I do, I do in in the source query. 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 4, 2014 at 9:39 pm
The source is SQL Server
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
February 4, 2014 at 9:51 pm
Are you able to handle those NULL values in the query for the datasource for this report? Changing that NULL to a different value such as 0 is a bit easier to handle in SSRS - though it can be done both ways.
Than it is a matter of creating the if statements for the formatting within each cell.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2014 at 5:41 am
Yes I can change the NULLs to 0s on the database side.
Thanks
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends
February 6, 2014 at 7:39 am
Koen Verbeeck (2/4/2014)
Normally I don't calculate conditional formatting, but when I do, I do in in the source query. 😉
😀 Well played!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply