Showing posts with label rs2005. Show all posts
Showing posts with label rs2005. Show all posts

Friday, March 9, 2012

Row count from another table?

Is it possible to directly get the row count of a different table in a RS2005 report?

I'd like to use this row count number in a calculation in another table...

This would be a lot cleaner than creating a new dataset to provide me with this value.

Thanks!

Alright, figured this out. Just had to use RowNumber("NameOfDataset") to return the number of rows in a table created by a dataset. Also, RowNumber(Nothing) returns the row number of a row in a table.