February 28, 2014 at 12:41 pm
Hi,
New to SSRS..I am trying to conditional format a filed based on the following logics:
if the date in 'field B' is less then TODAY() then format the 'field B' as Background Color Red and Font color White,
if the date in 'field B' is equal to TODAY() then format the 'field B' as Background Color Yellow and Font color Black.
I understand I can go to the Properties for the Font and click on expression and then go to Common Function and select date/time...and that is it. Can you please help? Thanks in advance!
Sincerely,
SJ
February 28, 2014 at 3:40 pm
One additional thing I wanted to mention is this field is populated by the query below. I am not sure if this has to do anything with it.
, CASE
WHEN isnull(cv2.Accepted,0)='True' AND cv2.Visit ='V2' AND cv2.StepNo='3' THEN 'Y'
ELSE CONVERT(varchar,[dbo].[fn_Get_WorkingDays] (co.PlannedGoLiveDt, -10),101)
END AS 'System Verified'
March 1, 2014 at 5:27 pm
Any one please..??
Thank you!
March 1, 2014 at 7:21 pm
if the date in 'field B' is less then TODAY() then format the 'field B' as Background Color Red and Font color White,
if the date in 'field B' is equal to TODAY() then format the 'field B' as Background Color Yellow and Font color Black.
You can accomplish this by using conditional formatting...
Right-click the textbox you wish to format,
choose Textbox Properties
Click on FONT in the left pane
Click the FX button next below Color
=IIF(Fields!FieldB.Value<TODAY(),"Red","Black")
March 1, 2014 at 8:03 pm
Hi pietlinden,
Thank you so much for your time and effort. This worked for me.
Have a great weekend !
March 3, 2014 at 2:25 pm
OK, so this is still related to a date format so I am recycling the post from few days ago.
How do I go about formatting a cell when date in Col A is 'within' date in Col B MINUS 10 days?
Please suggest..thank you very much !
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply