>>>>Hi Don,
>>>>>>
>>>>>>How can I save my report into text file? If I just try to write something like REPORT FORM myReport TO FILE myFile, myFile looks strange - populated with symbols, which I can not understand. Is there any easy solution?
>>>>>>
>>>>>> Thanks in advance
>>>>>
>>>>>Did you try the ASCII keyword?
>>>>>
>>>>>report form xxx to file (myfile) ASCII
>>>>
>>>>
>>>> It helps, thanks a lot. Although my report looks much better in Preview - Print, than in text file. But it's minor...
>>>>
>>>> Thanks again.
>>>
>>>There is a known bug with VFP5 & 6, with extra blank lines being inserted into the ASCII files (MS KB Ref Q172851).
>>>
>>>If this is the problem with your file, the suggested workaround is to set
>>>_ASCIIROWS = 30
>>>prior to the report form ... ASCII command.
>>>
>>>hth
>>>Paul
>>
>>The extra blank lines actually come from the spacing and size of the fields in the report. If you make sure there is NO extra space in the band above or below the field, you can usually eliminate the extra lines.
>
>I think the emphasis should be on the 'usually', I've never managed to eliminate all of the blank lines, especially in a long report, by playing around with the layout I can reduce the number of lines, but not eliminate them totally.
>
>With the original DOS & Windows (2.5/6) Foxpro, I could produce the reports without the blank lines, since converting to VfP 5, I've never managed.
>
>I've got one report generating in excess of 20,000 lines that I produce occassionally & use other tools to scan the produced output in a formatted manner & I usually pre-process the output to get rid of the extra blank lines.
>
>but thanks for the advice, anyway
>Paul


Another thing you have to be careful of is the font and properties selected for the fields on the band. If you choose a font and/or properties to that font (bold, etc.) that doesn't quite measure out exactly to an even multiple, you'll get extra lines that way, too. I can't recall if it totally eliminates the extra lines in all situations and report lengths, but it seems to do a pretty credible job.