Sorry! I typically break it down into separate records when I need to do something like that from data stored that way. This sounds like a problem for the VFP Report GODDESS (Cathy) !!!! :O)

Tracy

>Hi Tracy,
>
>Thanks for the help. In my situation, I have both types of detail data in the same record. In other words, if I have four detail records, I need to print four lines containing the first type of information, then I need to print four lines containing the second type of information from those same records. I don't think VFP can handle this situation (without some fancy record pointer manipulation), but if you know a way, please pass it along. I'm currently in the process of creating separate records for each type of data.
>
>Thanks again.
>
>>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.
>>