Get table row count outside scope of table in SSRS 2008

Question

I can count the rows in the dataset that the table consumes, but this doesn't return the right value as the data in the table is grouped.

I need to know the table size in order to dynamically size a chart that appears along side the table.

CountRows is obviously no good as you have to be in the scope of the table, which I'm not.

Any ideas?

Answer 1

How about determining the number of rows you'll have this way: [# of Header Rows] + CountRows("[DataSetName]") + CountDistinct(Fields![group1groupby].Value, "[DataSetName]") + CountDistinct(Fields![group2groupby].Value, "[DataSetName]") ... etc?