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

Newbie question...

edited February 2005 in Subreports
Hi,

I am just starting to use sub reports, so once you've all picked yourself up
off the floor wondering what stone I've been hiding under all this time can
someone please answer this question.

I have a report which has two subreports, one is titled External Transport
with rows for each time of said transport, each row has three columns,
TransTime, TransName and Total people, the second is titled Internal
Transport and has the same columns in each row.

So this is how it should look

Date : 26/02/2005

External Transport
=============
Time Name Total People
------------------------------------------------------------------
10:00 21 Seater 18
11:00 Bungy Bus 15
etc etc

Internal Transport
============
Time Name Total People
------------------------------------------------------------------
10:00 8 Seater 8
11:00 Van 5
etc etc

So I started by putting the sub report in the Detail band, but then External
Transport and the Column Titles appear for each time it seems.

So how can I get these to only appear once.

Many thanks in advance...
Colin B

Comments

  • edited February 2005
    Hi Colin,

    If you are placing these subreports inside the detail band of your main
    report and your main report is connected to a dataset, the subreports will
    print in their entirety each time the main report traverses to a new record.
    In order to see each subreport only once, you can either disconnect the data
    from the main report or move the subreports to another band.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2005
    Hi Nico,

    Thanks for your reply, but I don't think I explained myself very well given
    your answer.

    What I was seeing was when I was creating the rport with the sub reports in
    without any data and then going to the Preview tab, and External Transport
    appeared many times, but obviously I wanted the detail within the sub report
    to repeat until the JIT pipeline reaches EOF, however I rebuilt the report
    and that problem disappeared.

    I now have data filling the JIT pipeline and putting the information into
    the Ext. Trans. sub report, and the Ext TRans Header now appears only once,
    but the detail in that sub report overwrites the heading for the Internal
    Transport sub report. I will obviously play arond with it and re-review the
    examples, but if there anything springs to mind that would be great.

    Thanks again
    Colin

  • edited February 2005
    Hi Colin,

    Sorry about that :).

    If you set the ShiftRelativeTo property of the Internal subreport to the
    External subreport, you should not see any overlap. This is a published
    property so it is available in the Delphi Object Inspector as well as the
    popup menu of the subreport object.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2005
    Hi,

    Well that sorted it.

    Thanks a lot for your help and prompt responses, I'm sure I haven't even
    scratched the surface using ReportBuilder, but what is clear is how
    comprehensive your product is, awesome.

    Cheers
    Colin
This discussion has been closed.