Record Count?
Hello,
How can I get a total recod count for a report and display it?
I have setup the report to 'two-pass' and also created a Calculated Variable
with the 'Count(*)' and I also set it to look-forward := TRUE
the problem is that it counts correctly the # of records for each page and
as each page gets printed the # gets increase and at the last page the total
# is correct. I would like to see that total # in the last page being
display in the first page as well, in other words: I would like to see the
real total # in every page.
I think it has to do w/ traversing the dataset... is there a way to
acoomplish this?
Thanks
Isi R.
How can I get a total recod count for a report and display it?
I have setup the report to 'two-pass' and also created a Calculated Variable
with the 'Count(*)' and I also set it to look-forward := TRUE
the problem is that it counts correctly the # of records for each page and
as each page gets printed the # gets increase and at the last page the total
# is correct. I would like to see that total # in the last page being
display in the first page as well, in other words: I would like to see the
real total # in every page.
I think it has to do w/ traversing the dataset... is there a way to
acoomplish this?
Thanks
Isi R.
This discussion has been closed.
Comments
The easiest way to do this would be to create a new dataset that
pre-processes the count of records you are traversing and displaying that
value on your report. Since the count wil be pre-processed, you will not
have to generate the report twice to get an accurate count.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com