Solved

SSRS 2005 Roll Up Average in Report

Posted on 2012-04-02
3
1,221 Views
Last Modified: 2012-04-08
I have a report that currently lists data like:

DEPT         %                         <--Row
-------------------------
Supply          18.00 %             <--Group
Marketing    12.01%
Sales              5.03%
...
--------------------------

I need to be able to provide a rollup of the percentages. So in this example it would report back 11.68%

The issue is that the '%' column expression is
=round(sum(iif(Fields!MTR.Value = "False", 1, 0))/Count(Fields!MTR.Value),2)

So what I am 'trying' to do is something like
=AVG(round(sum(iif(Fields!MTR.Value = "False", 1, 0))/Count(Fields!MTR.Value),2))

but I get an error about
'The value expression for the textbox 'textbox71' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggreagte functions.

Ideas for a work-around?
0
Comment
Question by:edrz01
  • 2
3 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 37800110
0
 

Accepted Solution

by:
edrz01 earned 0 total points
ID: 37803088
No, but thanks.

I found a work around by creating additonal subreports that summarized the data and put them on the overall report. Not the way I wanted but I was against a time crunch.
0
 

Author Closing Comment

by:edrz01
ID: 37820896
Not a valid solution
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now