Is it possible to have the data from 2 subreports show up together and not separately?  Allow me to clarify, I have a purchase order report I do on a monthly basis.  Some PO's are OPEN (PO table) and some are CLOSED (POHIST table).  I use the LastFullMonth filter on the orderdate field for showing the last full month.  What I was wondering is can I have the data from the 2 different data sources displayed all together in order by PO Number rather than one report displaying first and the other at the end.  Hope this makes sense.  TIA!!

Edited by BrianBischof - 19 Nov 2007 at 2:07pm

Thanks.  You are the man!

I'll admit that I've never really used the SQL Expression bit before.  But, when I look at it, it seems to be using single quotes around the field names, not double quotes.  Could that be your issue?

What kind of database are you running this against?

I think I found my problem.  I was trying to create the command int he expression not the command area.  I will try it and let you know.  Sorry about that!

No linking is necessary. What you are doing is creating two distinct lists of data from two different tables. The UNION keyword then appends the second list to the first list into a virtual table and makes it all appear as one single table. Thus, the number of rows in the new table will be equal to how many rows are in the first SELECT plus how many rows are in the second SELECT.