Post reply

Grouping by weeks with daily breakdown in SSRS

  • December 31, 2010 at 6:47 am

    #232557

    Hi All,

    I have a query concerning SSRS and displaying data. My report will consist of a weekly breakdown of week numbers and sum of hours. Showing something like this

    12/06/10 351

    19/06/10 342

    26/06/10 399

    And then on clicking/toggling the week data cell(s) a breakdown by day will be displayed. I have completed the daily breakdown and written a function to return all weeks in 2010 but my difficulty lies in grouping by the week.

    In the layout tab for SSRS, I have created a group on the week value and date value, and have the week value appearing in the group cell, but it creates an additional blank line below each day breakdown.

    Could anyone help me?

    Thanks very much

  • December 31, 2010 at 11:26 am

    #1268166

    Same happened with me some days back. I executed my query and found that some records have the date column NULL. Use SSRSLink to get some other info as well.

    lucky

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

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