Solved

Running Total SSRS error

Posted on 2014-12-09
2
183 Views
Last Modified: 2014-12-27
I have an SSRS report that should reflect a running total in the MTD+/- of the Daily +/- column.  When I attempt to do this I get an error stating

The Value expression for the text box 'TextBox12' has a nested aggregate that specifies a dataset scope.  Inner aggregates cannot specify a dataset scope.

Any suggestions?
running-total.PNG
0
Comment
Question by:rcowen00
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40490841
Can you alter the originating SQL query, and calculate it there using OVER() instead of in SSRS?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40491185
WHat is the formula for the daily total?

mlmcc
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 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