Re: 2 detail reports from the one master?

On Thu, 6 Feb 2003, Tom Nesler wrote:

> > I'm trying to create a report that has two detail report sections
> > that are independant of each other but relate to the same master and
> am
> > not having much luck.  Can anyone point me in the direction of an 
> > example or info on how to do such a thing?  I've looked at the
> examples
> > included with delphi (pro 5) but they seem to have a master with a
> > detail or a master with a detail that is master to another detail.
> 
> Actually no...  Banded report generators are built like layer cakes...
> on the base detail band as opposed to printing from the top down. 
> Because there is only one detail band, you can't print two detail
> report sections...:-(

Crystal Reports offers a "subreport", which is a complete but not
independent report which you can drop into a report band.  I don't think
QR offers anything like that, but you may be able to imitate it with
composite reports and code, depending on how many master records you're
dealing with.

If the two detail sectons look a lot like each other, you may be able to
use queries that fill a temporary table which then can be printed like a
single detail band. The devil's really in the details there, though.

If all else fails, you could write code to extract the data from the
tables, format it as text, then use it to fill two memo fields in a single
detail band.  An ugly way to go, but it'll make a good story :-).

Best,
Peter

> Tom Nesler



                        Entropy isn't what it used to be.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/LIgTpC/vN2EAA/xGHJAA/i7folB/TM
---------------------------------------------------------------------~->

=============================================
QReport Artist 5 - http://www.mensand.com/
The new version is available for Delphi 5.0 ,
Delphi 4.0 and Delphi 3, BC++Builder 3.0. and BC++Builder 4.0 
============================================= 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/