Post reply

Monthly Report with data for every day of the month.

  • July 6, 2011 at 5:25 am

    #240442

    Hi,

    I need to generate a monthly report in SSRS as shown in the spreadsheet.

    I want to split the Date parameter into two rather than having a calendar. One drop down menu to select the year & one drop down menu to select the month.

    When I select the Year & Month I need to show the report for that particular month. The day field is the days of the month in spreadsheet.

    I did post this on the SSRS 2008 Forum, but had no response. Please help!!!!!!!!!!!!!

    Regards,

    Nithin

  • July 6, 2011 at 5:43 am

    #1348846

    Make the first parameter the list of valid years for your data (make sure it's still valid as the years go by).

    Make the 2nd parameter use the @year parameter. This will force the list to refresh itself when you change the year.

    Then in the main dataset you need to reconstruct the date range.

  • July 6, 2011 at 8:25 am

    #1349013

    Thanks for the timely help. Will try implementing as advised. :-):-):-)

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

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