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

Report embedded in an app page problem

edited February 2003 in General
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

Comments

  • edited February 2003

    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
  • edited February 2003
    Thanks Nard,

    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

  • edited February 2003

    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
This discussion has been closed.