I just wanted to post the solution that I used to resolve this issue, so that anyone else who might run into this can have an alternate answer. [lipstick2]
This is what I used to get the highlighting within a group.
=iif(Fields!ClientName.Value = Previous(Fields!ClientName.Value) and...
I am using SSRS 2008 R2 with SQL 2008. I have a report that lists dates that a client uses a service. I have grouped on the client name and the detail is the dates. I am trying to check if a date for a specific client is duplicated. To do that I am using an IIF statement...
Using SQL 2005 and SSRS 2008 R2. I have a list of clients who have had appointments within a date range. So I have columns with Client name, appointment date and time, and Appt Kept (Y/N). I need to return those who have consecutive no show appointments. That is for 2 or more appointments in...
OK.. This is the code that I entered per your help.
=IIf(Fields!DueDate.Value.ToString.Length > 0 And Fields!DueDate.Value > DateTime.Today And Fields!DueDate.Value< DateTime.Today.AddDays(30), "LightCoral", "White")
It does what it is supposed to.. It highlights the background of this field...
Using SSRS 2005 with SQL 2005. I am working on a report and I want to change the background color of a date field if that date is not null and is within 30 days of the current date. I have used every variation that I can think of in the background properties expression, and I keep getting error...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.