Solved

Running Total in SQL Reporting Services

Posted on 2009-04-01
11
963 Views
Last Modified: 2012-06-22
I am trying to add a running total to a textbox in SQL reporting services and i'm getting the following error:
[rsInvalidAggregateScope] The Value expression for the textbox textbox11 has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.

I have attached the code for the textbox. I do not have any groups other than Header, Footer, and Detail, so I'm not sure what to use as the second arguement in the RunningValue function.

Any help would be great....Thanks.
=RunningValue(Fields!InvtID, Count, "Table1_Details_Group")

Open in new window

0
Comment
Question by:ochness
  • 6
  • 5
11 Comments
 
LVL 25

Expert Comment

by:reb73
ID: 24041684
Try leaving the scope blank..
0
 
LVL 25

Expert Comment

by:reb73
ID: 24041687
Or try -

        

=RunningValue(Fields!InvtID, Count, Nothing)
0
 
LVL 1

Author Comment

by:ochness
ID: 24041703
Thanks for the response....I tried that and I get an error that says I have an incorrect number of parameters for the function.
0
 
LVL 1

Author Comment

by:ochness
ID: 24041720
Tried that as well and I get the same error as the original posting. Thanks for your suggestions...anything more?

This is a text box that is all by it's self under the detail line.
0
 
LVL 25

Expert Comment

by:reb73
ID: 24041846
Strange, see the link below which suggests using Nothing..

http://msdn.microsoft.com/en-us/library/ms159136(SQL.90).aspx
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 1

Author Comment

by:ochness
ID: 24041943
Well I see what they are saying...just doesn't work. HMMM...not sure what to do now.
0
 
LVL 1

Author Comment

by:ochness
ID: 24042040
Well this works: =CountRows()

But I'm not sure if that is the best thing to use. I guess it is fine since each Inventory ID (item) is on it's own row.

Any thoughts?
0
 
LVL 25

Expert Comment

by:reb73
ID: 24042042
Try using the Expression builder in Report Designer..

http://msdn.microsoft.com/en-us/library/ms157376(SQL.90).aspx
0
 
LVL 1

Author Comment

by:ochness
ID: 24042083
I have been using the Expression Editor and I get no red lines when I use =RunningValue(Fields!InvtID, Count, Nothing) so I'm not sure what is going on.
0
 
LVL 25

Accepted Solution

by:
reb73 earned 125 total points
ID: 24042155
Well, I guess the CountRows() should be fine for your report in its current state..

If you have a dataset declared, try using the dataset as the scope parameter, like -

=RunningValue(Fields!InvtID, Count, "DataSet1")

Where DataSet1 is the dataset containing InvtID..
0
 
LVL 1

Author Closing Comment

by:ochness
ID: 31565434
This works...Thanks. I tried to use the dataset name, but I didn't use the quotes, so I added the quotes and it works. Thanks for your help with this.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 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

14 Experts available now in Live!

Get 1:1 Help Now