http://i712.photobucket.com/albums/ww125/thegloworm901/PARTS_zpsc839089a.jpgI am creating a report that will consist of data from 3 queries.
My thought is to create a report that contains the results of each query in its own subreport.
The first query/subreport will pull part number information which is one row of data.
Second query/subreport pulls the possible vendors for the part number in query one. Can be multiple rows.
Third query/subreport pulls open purchase orders for the part number in query one.
I then have to figure out a way that for each part number in query one, I stagger the correct vendor and open order information in the same section before it has the next part number.
I have attached an example spreadsheet that was given to me to work off of. As you can see, there is one part number in the first section. You can see the multiple entries in sections 2 and 3.
That is what I need to recreate in Crystal.
Edited by gloworm - 08 Jan 2013 at 11:52am