Friday, March 23, 2012

Number of records in table

Hi!
How I can calculate number of records in the table which has filtering?
E.g., DataSet "dsABC" return 1000 rows. After filtering table contains 300 rows.
Function:
= CountRows("dsABC") return 1000.
How I can get 300?

Alexey,

I'm not sure I completely understand your question. Do you want the number of rows to show up on the report? Is this correct?

|||Thanks. It's correct.
I found workaround - create expression in the table footer (e.g. texbox name "TableRows") :
= Count()
Then in the textbox on the report header area I create exppression:
=ReportItems!TableRows.Value
It's work!

No comments:

Post a Comment