So... I developed a report in my BIDS of SSRS 2008 R2. The report is working absolutely fine. But then comes the panic when I deployed it on the server that doesn't have R2. It has SSRS 2008 and slaps me with 'Aggregate functions cannot be nested inside other aggregate functions' error. To note: the TargetServerVersion property of the project is set to SQL Server 2008. Where could I be wrong? Does RunningValue function behave different between the two versions? I read msdn but couldn't click much. Please advise Microsoft Techie

Did you read the link I provided in your other post? You need to have a read of the following link on SSRS 2008 R2 breaking changes to see whther your report can be deployed to SSRS 2008 http://msdn.microsoft.com/en-us/library/ms143380.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Jeff, I did read the breaking changes article... I still fail to understand why RunningValue is giving me the error. I have a matrix in my report and am trying to get cumulative total of each col using RunningValue. Here's what I have written: RunningValue( sum(iif(fields!Group.Value = "A", fields!Amount.Value, 0)) - sum(iif(fields!Group.Value = "B", fields!Amount.Value, 0)) , Sum, Nothing) Any tweaking required here to make this compatible with 2008? Please advise.Microsoft Techie

Hi {P} Have a read of this thread. It may provide some insight into your problems http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b6be86e8-66ab-4044-9b44-a666f254f176/Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Went through all again. Unfortunately can't figure out what the solution is to my issue... setting scope in sum? defining report variable? at what level?.. ?... ? Am totally numbMicrosoft Techie

Hi, Just run the below wxpression and check if you are getting the same result or not. =RunningValue( (iif(fields!Group.Value = "A", fields!Amount.Value, 0)) - (iif(fields!Group.Value = "B", fields!Amount.Value, 0)) , Sum, Nothing) Hope its helpful....Pavan Kokkula Tata Consultancy Services.