Splitting a report
I have a report which is linked to the following tables.
Tickets Table. Contains Ticket no. / ticket status / status change dates /
Customer Site belonging to / etc. etc.
Customer Table. Contains Customer details .
Site Table. Details of site / whether any payments to site owner / amount to
pay / payee details.
My report brings back the following:
Ticket No Paid date Reg Number Belongs to Site No Payment
amount Payment to
034 01/02/05 GHHG67 PT Parking 789
?10 Mrs wilson 3 anywhere street.
etc. etc.
I need to create a subreport split on individual site numbers.
i.e. if there is one ticket for site 789 create a one line report.
if there are ten tickets for site 789 create a ten line report
So I would have one main report (exported to excel) containing 200 lines
then possibly 20-30 other reports based on the site number.
The main report tells the Belongs to company the total due to them and the
sub reports gives the payments to the payments to clients.
Am I attacking this from the right angle?
Any help appreciated
SteveW
Tickets Table. Contains Ticket no. / ticket status / status change dates /
Customer Site belonging to / etc. etc.
Customer Table. Contains Customer details .
Site Table. Details of site / whether any payments to site owner / amount to
pay / payee details.
My report brings back the following:
Ticket No Paid date Reg Number Belongs to Site No Payment
amount Payment to
034 01/02/05 GHHG67 PT Parking 789
?10 Mrs wilson 3 anywhere street.
etc. etc.
I need to create a subreport split on individual site numbers.
i.e. if there is one ticket for site 789 create a one line report.
if there are ten tickets for site 789 create a ten line report
So I would have one main report (exported to excel) containing 200 lines
then possibly 20-30 other reports based on the site number.
The main report tells the Belongs to company the total due to them and the
sub reports gives the payments to the payments to clients.
Am I attacking this from the right angle?
Any help appreciated
SteveW
This discussion has been closed.
Comments
Unfortunately there is no real way to "split" a report into multiple reports
unless you are using separate individual subreport objects. I would suggest
creating two pieces to this project, one that prints your entire 200 line
report and one that dynamically creates each individual report by sending
different data into a single report object. This would then just be a
matter of dynamically changing your query to send the proper data to the
report object before the individual report was saved down and the next
report generated.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com