Newbie question...
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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