Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m_singh
Starting Member
2 Posts |
 Posted - 2011-04-04 : 10:25:39
|
| I have configured Windows sever 2008 and Installed Sql 2008 on it. I am getting following error when build or deploy the report:[rsAggregateofAggregate] The Maximum expression for the chart 'DataBar2' 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 aggregate functions.I stuck here.is I am doing something wrong or i missed somethinga help will be appreciated.msingh,snl |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2011-04-04 : 10:54:39
|
We'll need to see what your query looks like...but from your error, I'd say you're doing something like avg(sum(...)). If you are... don't do that.Corey I Has Returned!! |
 |
|
|
|
|
|
Error: Aggregate functions cannot be nested inside