>Hi Naomi,
>just a thought, can you do the work in the cursor instead of the report form?
>
>What I mean is, can the cursor be set up with a field like nOrder and then everything that gos in the first part could be nOrder 1, the second part nOrder 2 etc. Then order by nOrder and any other fields you might need to order by.
>
>I have done that with some complex reports and it worked for me.
>
>
>Julian
Hi Julian,
Yes, I guess it will work for me as well. I already suggested to split this report into two and even started to work on that second report, but may be I should go back and use that idea instead. It will be slightly tricky with 'Print When' conditions to achieve the layout we wanted, but doable.
It's just since I need 3 separate layouts, I will have to place different fields one on the top of the other - I don't like it much as it makes designing this report complex.
If it's not broken, fix it until it is.
My Blog