I do this more often than I care to think about. What I do is something that Cathy Pountney recommended. I add fields to the cursor for a print when condition. Let's say I call the field cprint and make it c(1). If I need two different detail bands I set the field value to the records that go in the first detail band to '1' and the records that get printed in the second detail band I set the value in the cprint field to '2' This means of course that I have to step through the cursor before I run the report so I can set the appropriate values. Then when designing the report, I set the print when value of the report object to cprint=.t. and set it to remove line if blank. If I want absolutely NO white space I will set all of the values of the detail objects on the report and then lay them on top of each other. But when I have different headings that must go above each group that need to print whether there is detail or not, I either do the same with column headings (use the print when clause) or I will put the headings with the print when settings in the detail band also and I create a header record (for the column headings) in the table that comes just before the detail records for that group which then prints just before the detail lines for that group because the record is before it and it doesn't print again because of the print when clause (it can just be set to check for empty() in that case so the record doesn't print if there is no header information in the header fields.

>I have a view that pulls information from several tables using joins. In the detail band of a report, I need to print two different types of information. I need to print all of the records for info type 1, and then print the records for info type 2. I know how to do this when type 1 and type 2 are in different records, but in my current scenario both types are in the same record. I believe what I want is referred to as a "sub-report" in other report engines, such as Crystal. I'll separate the data into separate records if I need to, but I want to know if there is another way using the data that I have.
>
>Thanks,
>
>Joel