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!

Register Log in
  • Congratulations dencom 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: *

  • Users: tipofapin
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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