Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1993
  • Last Modified:

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.
0
M3hcSS
Asked:
M3hcSS
1 Solution
 
HillwaaaCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now