With the help of David this is exectly what I did. I was having problems combining the two cursors, but with the code from that other thread it was a snap. Thanks for reminding me to 'Group' the controls, it makes maintenence on the report A LOT eaiser. :)


Eric Stephani



>>I have basically two different tables that I want to put on the same report. Is there a way to create multiple detail bands with the report designer? I know I could combine the two tables into one and have a field to determin which table it was. I could then create a data group in the report but this will only allow me to one header band for the group. So, I want to have two seperate header and detail bands on the same report. How can I do that.
>>
>>Eric Stephani
>
>Eric,
>
>You're off the right start! Put all the data from both tables into one cursor, being sure to add a new field that determines which table the record was in. Create a Data Group that breaks on that new group. In the Group Header, add all the fields for your "first" band, setting the Print When logic to RECTYPE = '1'. Do the same with all the fields in the Detail band and the Group Footer band, being sure to set the Print When to "1" for each of the items.
>
>Then do the same for all the fields you want in your "second" band. Add the objects and set the print When to RECTYPE = '2' for everything. It gets real ugly when you place all these fields on top of each other, but that's what you have to do.
>
>To make it easier to design, I usually do everything for the first band .. then jump over and create a new dummy report and layout all the objects for the second band. Once I have everything all set, including the Print When, I just do a cut and paste and add the band 2 objects from the dummy report back to the original report.
>
>Another thing you can do to make maintenance easier, is once you have all the band objects for #1 in place, highlight them all and select GROUP so they're all grouped together. Do the same with the band 2 objects. Then if you ever have to do maintenance, you can grab the entire set of objects and move them out of the way to a dummy report .. manipulate them .. and then put them back.
>
>Cathy