6-7 seconds doesn't seem like a big time, for such a big report.
Anyway, another method can be used, but only if each detail band is the same size. Just divide the total number of records by the number of records that fit on one page. For example:
lnRecordsPerPage = 20
select * from MyTable where... into cursor Temp nofilter
lnTotalPages = ceiling(_tally, lnRecordsPerPage)
Otherwise, if the number of records per page is not fixed, you have to run the report twice.
>Hi Craig,
>
>That's exactly what i am doing. It takes almost 6 - 7 seconds with 1000 records to actually view the final report. Thats a bit too much bcoz when the data increases, it will definetly go slower.
>So I wanted to know if there was some better solution.
>
>
>Thanks & Regards,
>JD.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)