Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Carriage Return & Line Feeds
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00529105
Message ID:
00529128
Views:
13
>When the following code is run I get a report titled MFGREPT.TXT
>
>report form nfna to file MFGREPT ascii
>
>When I open this text file everything that was in the detail band is double spaced. Why? Can this be corrected?

The creation of text files from the REPORT command needs some special planning. One thing you can do is to ensure that the font for all is a non-propotional font like Courier New. This will ensure that the character spacing is ok when you view it. Then you need to ensure that the output fields dont go over the bounds of what you have set. As the to file option tends to wrap the text around to a new line. Which is what I think is happening to you. I have created quite a few report files to text and have found that I had to do many trial and errors to ensure that the detail band did not wrap around. So my data had to be no more characters across than can fit converting it to text. If there are too many characters to fit on a line then VFP will wrap and continue. Try moving the fields over or closer to each other. Try taking a field away and see if the double spacing goes away. Try closing up the space the detail area takes up (verticle). HTH
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform