You can also "stack" the fields vertically on top of each other in the detail band (i.e. in a seperate row, not actually on top of each other), and then check the "remove line if blank" option in conjunction with the "print when" option. This removes the line containing the fields irrevelant to the current record so that you don't get a blank line in the report. This makes for an easier to read layout in the designer.

tc

>Thanks for your reply. I have solved this by creating a field with the bandno. and storing all the info in one table. Using the 'print when band=1' only the fields for that band are printed. Allthough the layout is a mess (because several fields are on top of eachother), I get my output, and that's what counts. I have hoped that there was a better way...
>Nice weekend!
>
>>You can't do something like that with FoxPro's Report Designer. Even if you modify the frx file according to my tip "Hidding unwanted bands..." from Tips&Tricks, you can't do it. You can create multiple Detail bands, but you can not set a dbf to be scrolled for each one. I.e. the report will scan just one dbf.
>>
>>What you can do: you can create a cursor with memo fields. For each band, you must build a memo field (build it by appending char strings exactly in the way you want them in the report). Print the report from this cursor. Although, you can not set different styles for different fields...
>>
>>Vlad
>>
>>>I need something like this (this is an example!!!):
>>>1 Invoice: 01/01/97 100
>>> 02/02/97 200
>>> ---
>>> 300
>>>
>>>2 Letters: Letter1 cc: ...
>>> Letter2 cc: ...
>>>
>>>3 Appointments: 1 With ...
>>> 2 With ...
>>> 3 With ..
>>>
>>>4 TODO: Job1 High
>>> Job2 Low
>>>
>>>
>>>This information is stored in several databases, and each band must have it´s own layout... Getting the picture??
>>>JP
>>>
>>>>What do you mean by "multiple detail bands"?
>>>>
>>>>Vlad
>>>>
>>>>>Hello,
>>>>>
>>>>>How can create a report with mutiple detail bands. I have looked at ReportX, but can't figure it out. Now I am using FoxFire, but can't find the power / benefits. Which way to follow???
>>>>>
>>>>>TIA
>>>>>Greetings,
>>>>>Jean-Pierre