>That would work if my report was as simple as just a letter. I can't seem to do what I want to with the report writer in foxpro. I have about 100 fields to put on a form I have created and have arranged them in 2 columns on a single page in the report designer. Everythings works fine when the text and fields from one of the columns, lines are removed when blank. But then I put the 2nd column of fields on the page this doesn't happen. I assume that it is because there are fields in the same horizontal space. This is where I am having my problem and I have yet to find a way around it.
>
>Rob Newell
The only suggestion I have is to use memo fields or arrays and build the data ahead of time. For example, you can use one memo field for the left column and one for the right column. Then you would have to preprocess your data, building a giant string with the data and CHR(13)+CHR(10) to break up each different line. The down side is that if you have to line up figures and stuff, you pretty much have to use a non-proportional font to make this work. I've created some pretty complex reports using this trick and the end results works .. it's just a PITA to deal with.
The only other thing you can try is to create some data groups based on the expression of RECNO(). I've used this trick when I've had tons of fields and had to help keep chunks of information lined up within one specific detail band. It's hard to say if this would help you without knowing the specifics .. but it's a suggestion that you could play with.
Cathy