March 30, 2010 at 4:06 pm
Hi ALL,
I am trying to get the percentage value in a matrix report in SQL 2005. I need to a way around the aggregation of aggregate functions in the expression box. I am trying to use Sum(Count(ItemID)) which fails as expected. Whats the loop around this?
Thanks,
Ninja
March 31, 2010 at 8:37 pm
This has finally been resolved in SSRS 2008 R2 "Calculating Aggregates of Aggregates" http://technet.microsoft.com/en-us/library/ms170438(SQL.105).aspx
For the time being you could probably setup a Function in the Code section and then pass in your values. Something along the lines of this example http://stackoverflow.com/questions/213002/calculating-grand-totals-from-group-totals-in-reporting-services.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 1, 2010 at 1:43 pm
Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy