<div>
WHat is the formula for the daily total?<br />
<br />
mlmcc
</div>


WHat is the formula for the daily total?

mlmcc

<div>
<div class="content wysiwyg-content">
I have an SSRS report that should reflect a running total in the MTD+/- of the Daily +/- column. &nbsp;When I attempt to do this I get an error stating <br />
<br />
The Value expression for the text box 'TextBox12' has a nested aggregate that specifies a dataset scope. &nbsp;Inner aggregates cannot specify a dataset scope.<br />
<br />
Any suggestions?<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/12_w50/887097/running-total.PNG" target="_blank" title="running-total.PNG (6 KB)"><img alt="running-total.PNG" class="file-block lazyload" style="max-width: 675px;" data-src="https://filedb.experts-exchange.com/incoming/2014/12_w50/887097/running-total.PNG" /></a>
</div>
</div>


running-total.PNG

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 SSRS error

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.