CountRows()

I've got a simple problem, but because this is my first report, I can't quite figure it out and it's driving me nuts!

I've got an ASP.NET web application with an .RDLC report. The report works fine, i.e. it renders data correctly. However, I cannot get the CountRows() function to work. I've got a cell in the group footer with the following:

=CountRows("grpBuyer")

And I'm getting the compiler error:

The value expression for the textbox XXXX has a scope parameter that is not valid...

"grpBuyer" is what is specified in the Grouping/Sorting property of the group header. I've also tried "TableRow2", which seems to be the name of the group header, but it yeilds the same compiler error.

Some please help!

Thanks, Alex

Hello Alex,

You have to pass group name (which by default is somewhat like "<objectname>_Group") to this function, you can get group name by right clicking on the object(table/matrix/list) and then click on "Group Tab" and there you will see all groups name for that object. You should pass exact name of Group, like i did =CountRows("list1_Details_Group") and it should work fine.

hope this will solve your problem.