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.

No comments:

Post a Comment