In MS Reporting Services, how do I use the CountRows function in a table cell with a drill down table?

When I put in anything at all in CountRows(blah) to try to count the number of rows in a table I get this error...

The Value expression for the textbox ‘textbox29’ 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.
LVL 2
M3hcSSAsked:
Who is Participating?
 
HillwaaaConnect With a Mentor Commented:
Hi,

If you are using RS2005 you should be ok if you put the following as the expression in your textbox:

=CountRows("DataSetNameHere")

Cheers,
Hillwaaa
0
 
M3hcSSAuthor Commented:
=CountRows("DataSetNameHere") placed anywhere on the detail line of a drill-down table gives the total number of rows in the DataSetNameHere.


=CountRows("DataSetNameHere", Recursive) placed anywhere on the grouping line gives the number of rows BELOW it--very interesting and useful.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.