asked on
SSRS: color cell complex query
Hi,
I'd need a sql query to color code a date:
Items = status NOT equal to 'Status01', 'Status02'
For all items which have date less then a week => green
older then a week => orange
older then 2 weeks => red
Items which have Status Status03
and have date
older then 2 weeks orange
older then a month red
Thanks for helping with the approach!
J
I'd need a sql query to color code a date:
Items = status NOT equal to 'Status01', 'Status02'
For all items which have date less then a week => green
older then a week => orange
older then 2 weeks => red
Items which have Status Status03
and have date
older then 2 weeks orange
older then a month red
Thanks for helping with the approach!
J
SSRSMicrosoft Server OSMicrosoft SQL Server
Last Comment
lcohan
ASKER
Thanks, but that s nowhere near to what my query should look like :-(
Can you help building the query syntax using dates?
Something like
=SWITCH(Fields!date.Value <= today-14, "Red", Fields!date.Value <= today-7, "Green")
Then if Fields.status stayus03 and date <=
Can you help building the query syntax using dates?
Something like
=SWITCH(Fields!date.Value <= today-14, "Red", Fields!date.Value <= today-7, "Green")
Then if Fields.status stayus03 and date <=
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Open in new window
where you need to place your actual date column criteria.