Solved

Running Total SSRS error

Posted on 2014-12-09
2
172 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video discusses moving either the default database or any database to a new volume.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 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

12 Experts available now in Live!

Get 1:1 Help Now