Re: 2 detail reports from the one master?

Hi Charlie!
--- Charlie Chambers <[email protected]> wrote:
> Greetings,
> Don't want to intrude on the thread but i've had a similar situation
> but not quite the same. I had a Master and slave that i wanted to put
> the data on a form with a form bitmap.  I could not get a banded
> report to work as i wanted. I worked around this by creating another
> datafile with each record filled with the data from the master(one
> record) and slave(many records).
> It's not a pretty solution but it did work. Is this a possible
> solution for your case?
> All the best,
> Charlie Chambers

Your comments are welcome!

This gives me an idea...Potentially you could create a single detail
query result set containing the data from both detail tables combined
into one large table.  Sort of like this:

[Master Key--][...Detail-1Fields....][...Detail-2Fields....]

Doing this, you would have blank fields in Detail-1 section when the
Detail-2 section was filled and blank Detail-2  fields when the
detail-1 fields were filled.

To get this type of result you need to do an outer Join so that you get
full records even when the matches are not complete.  If you can do
this then you would need to do some trickery to get your fields lined
up correctly.

For example, you might have a report with POs and Sales Orders needed
for each item.  Therefore your detail band would lokk like this:

------------------Detail band -------------------------
[PO Number][Due Date][Quantity][SO Number][Ship Date][Quantity]
------------------Detail band -------------------------

When you print this out it would look like this:            

  1234    12/12/02    1000
  1235    01/01/03     500
  1236    02/01/03     500
                              9990        12/31/02      500
                              9991        01/01/03      500
                              9992        02/01/03      500

Hope this helps.  Let us know how you did it and what other tricks you
used when you finish it.




=====
Tom Nesler

Live Long...Code Well... and Prosper! V

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

------------------------ 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/