Post reply

Calculate percent and matrix column position in ssrs

  • January 1, 2010 at 1:31 am

    #386031

    hi all,

    have build a report using ssrs 2005 ....attached the matrix format.

    have successfully created the total using subtotal option..

    how to create percent cell next to total column..tried to add new column but its locating under status group

    percent column should fit right to total column.. how to create this...pl guide..

    Thanks...Gugan

  • January 3, 2010 at 5:22 pm

    #1098262

    Hi Gugan,

    There are several approaches to this type of requirement - you may find it most maintainable to build the custom aggregate into your SQL query (if possible). Martin Cremer's article is a good introduction to this approach:

    http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/63415/[/url]

    Another approach is using InScope() functions. You can learn a lot of everyday SSRS techniques such as using InScope from the following article by David Leibowitz on simple-talk:

    http://www.simple-talk.com/sql/reporting-services/advanced-matrix-reporting-techniques/[/url]

    Enjoy!

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

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