?
Solved

SSRS 2005 Roll Up Average in Report

Posted on 2012-04-02
3
Medium Priority
?
1,253 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
 

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
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 …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

609 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