Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

multiple occurrences of report on one page

edited August 2004 in General
Hi,
I have a report that prints multiple times(4 per page) where I change the
JobID parameter and it produces a report for that Job only. What I have done
is, I use SQL to get all the data and use Groups and group by JobID...so
each report prints with its own data. All that works fine. Only thing is,
as you can imagine, it is quite slow especially coz I get the all data at
once.
Is there any way I can probably get data at for each Job by passing ID's
when the report starts running...like loop through a dataset or something??

Thanks
--
RB 6.03
Delphi 6

Cheers,
Shanil

Comments

  • edited August 2004
    Hi Shanil,

    ReportBuilder will traverse through all the given data as the report is
    generated. If you would like to limit the data the report prints, check out
    the AutoSearch capabilities of ReportBuilder. As far as trying to speed
    things up by only accessing certain bits of data at a time, you would
    possibly need to create multiple datasets and connect them to subreports
    inside your main report to do this.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.