Post reply

Subtotal on selected columns in SSRS Matrix report

  • June 17, 2010 at 6:26 am

    #223915

    I have a matrix table On left it is grouped on "Employee" and on top it is grouped on "Business Date", in data field I have three columns, StartTime, EndTime and TotalHours. StartTime and EndTime fields are datetime and TotalHours is Int.

    When I do a subtotal on group "Business Date", it displays three columns StartTime, EndTime and TotalHours. First two columns are irrelevant for me. How do I just calculate sub-total on TotalHours? I have tried all the ways, but couldn’t get the solution.

    Please some one chime in and give solution.

    Thanks in Advance

  • June 18, 2010 at 8:50 am

    #1182186

    The way I typically get around this is by doing the cross tab in the database. Then I just display it in a table. Jeff Moden has a great article about creating dynamic cross tabs and pivots here. http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D

    One of the benefits is that since you don't have to pull all of the data across the wire to aggregate it, it should render faster for your users as well.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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