can we know th number of the rows fetch from the DB?

hi,
is there a way to know how many rows the Data Set fetch from the Data source?
I want to stop the generate of the report in case fetch 0 rows from the DB, is it possible to do this?

Find more posts tagged with

Comments

egau

Hello mby,

I am not sure that's what you want, but you can use a computed column with the function "runningcount". This function return the number of row , starting at 1, so finaly you have the exact number of row generated in by the DataSet.

Hope I helped.

egau

mwilliams

mby,

With the same idea of a computed column suggested above, you could also just use "count" and it'll just repeat the total for each line.