multiple occurrences of report on one page
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
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
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com