Home Forums Reporting Services Reporting Services 2008 Development Report ignores WHERE clause in SPROC RE: Report ignores WHERE clause in SPROC

  • November 13, 2014 at 10:48 am

    #1758336

    Missed the obvious solution.

    Changed...

    WHERE f.shipDate BETWEEN (GetDate() - 7) AND GetDate()

    AND b.prodNumber NOT IN (widgetA, widgetB)

    to...

    WHERE f.shipDate BETWEEN (GetDate() - 7) AND GetDate()

    AND b.prodDescription NOT LIKE (%'widget'%)

    Doh!

    --- Remember, if you don't document your work, Apollo 13 doesn't come home.