Post reply

SSRS 2005 report - Filtering row grouping based on data in a column grouping

  • November 17, 2009 at 4:23 pm

    #216817

    Hi

    My report needs to show data for the specified period (normally a whole month). But for comparision purposes, it also needs to show historic data for the calendar month prior to this month, and also data for same month last year. eg. If user wants my data for Oct 09, then my report also needs to show data for Sep 09 and Oct 08.

    How do I get these dates in my query?

  • December 1, 2009 at 12:49 pm

    #1086050

    you could use "dateadd" in your query statement.

    You could do "union" to combine the select of the 3 different time periods and "dateadd" on the date field within your where statement to get the data necessary.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply