I don't know about Crystal Reports, but it sounds like you should probably use it if possible. If not, I have used a method involving complex print-when code and making the detail band function in extra ways. I name the textboxes (I just make up names as if they had such a property), and then I have each textbox's Print When call the program with its name as a parameter. I also use a second parameter to have the procedure return a value to print instead of Print When. You also need to change the band header and footer the same way. The you make a cursor which needs to contain or (through relationships) point to the applicable data. The cursor contains a number d_type associated with the detail-band type. You index the cursor so the second "detail band" records are at the end. And you make the band itself trigger by means of the number d_type.

It works okay if you don't need to change the headers or anything. And if the band & detail heights can be the same for both "reports."

Adam