Solved

Running Total in SQL Reporting Services

Posted on 2009-04-01
11
983 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Backup skipping a few tables 7 62
SSRS: My Data Source no longer has any dependent items ??? 2 81
tempdb log keep growing 7 56
Report Calculation - Cognos 2 15
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…

739 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