5

I have tablix named tablix2 and have 3 columns ,I want to calculate rows sum and count in 2 textboxes out of the tablix scope, I try this expression.

=RowNumber("Tablix2")

And

=CountRows("Tablix2")

And

=Count(Fields!ID.Value,"Tablix2")

Its always show me this error message:

The Value expression for the text box ‘Textbox7’ 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 dataset.

ASalameh
  • 783
  • 1
  • 8
  • 29

3 Answers3

7

You need to use a scope name which is valid. If you're outside of the tablix then you should use dataset scope probably.

Try something like

=Count(Fields!ID.Value,"DatasetName") or

=Sum(Fields!ID.Value,"DatasetName")

Sam
  • 7,245
  • 3
  • 25
  • 37
  • Thank you for answer but I need to perform the aggregate methods on tablix (tables) , not DataSet if you know any information i'll be thankful . – ASalameh Nov 27 '13 at 21:03
  • You can't use a scope that you're outside of (as the error message says). – Sam Nov 27 '13 at 21:38
  • Yeah I see , I solve it by using stored procedure with parameters in SqlDataSource before the report opened and make the Count through Dataset .Thanks fore helping . – ASalameh Nov 27 '13 at 21:45
1

Right Click on the tablix on the last row in the group (you have to do this in the "handle" area to the far left because you get a different right click menu if you click in the row area), then choose "Insert Row" and "Outside Group Below." Merge cells as necessary and drag a textbox into the one you want to put the value. Then put =Count(Fields!ID.Value) for the expression inside the textbox to get the group count, for example.

This worked for me, but I agree it is far from intuitive and doesn't appear to be documented well anywhere for what should be such a basic feature in a reportwriter.

Del Lee
  • 442
  • 1
  • 6
  • 20
0

I created a report footer and added this code to a textbox below. DataSet1 is the name of the dataset in the report (case-sensitive). Fields doesn't change. Sym is the name of the column in the details of the report,

=Count(Fields!Sym.Value,"DataSet1").

Marc Guvenc
  • 53
  • 5