Report embedded in an app page problem
Hi,
I have embedded quite a simple report in an application, using RB7.01 Ent.,
Delphi 6. The report is displaying master-detail relationship from 4 tables
each linked 1 -> many.
Job Head --> Job Movement 1
Job Movement 2 --> Job Leg 1
Job Leg 2
Job Leg 3 --> Item
Number
Item Number.
I am using 4 ADO queries, one for each table. However the master table
query, job head, only ever has 1 row, each detail query is linked using a
parameter fed from its masters datasource.I am using a sub-report for each
detail table. The problem is I am always getting an extra page at the end of
report, this displays only the information from the main header page and of
course no detail information as it has already printed this. Any idea why,
or where I am going wrong?
Thanks
Simon
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.458 / Virus Database: 257 - Release Date: 24/02/2003
I have embedded quite a simple report in an application, using RB7.01 Ent.,
Delphi 6. The report is displaying master-detail relationship from 4 tables
each linked 1 -> many.
Job Head --> Job Movement 1
Job Movement 2 --> Job Leg 1
Job Leg 2
Job Leg 3 --> Item
Number
Item Number.
I am using 4 ADO queries, one for each table. However the master table
query, job head, only ever has 1 row, each detail query is linked using a
parameter fed from its masters datasource.I am using a sub-report for each
detail table. The problem is I am always getting an extra page at the end of
report, this displays only the information from the main header page and of
course no detail information as it has already printed this. Any idea why,
or where I am going wrong?
Thanks
Simon
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.458 / Virus Database: 257 - Release Date: 24/02/2003
This discussion has been closed.
Comments
Without seeing the report layout, it is difficult to diagnose. Check all of
the layouts for the report and subreport to try to determine what causes the
page break. Check whether there are some title, summary bands with newpage
set to true. Or groups with start new page to true.
If you would like to send the layout in .zip format to
support@digital-metaphors.com we can try to check it out here.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
The last detail sub-report had 2 columns, once I removed its Title section
the problem resolved itself. Is that to be expected? Anyway its running very
nicely now.
Best Regards
Simon
I would need to see an example. Sounds like the report thought it could not
fit on the page for some reason.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com