Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tipofapin

    IIF Expression with Scope

    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...
  2. tipofapin

    IIF Expression with Scope

    Thanks for the suggestion.. But now I get an error that essentially says that there are "Too many arguments".
  3. tipofapin

    IIF Expression with Scope

    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...
  4. tipofapin

    return consecutive no show appointments

    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...
  5. tipofapin

    Change background color if Date is within 30 days

    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...
  6. tipofapin

    Change background color if Date is within 30 days

    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...

Part and Inventory Search

Back
Top