Exporting to a fixed-length file format 1

[jmstroup]

Hello,

I have created a report but want to be able to export the records using a fixed-length format. So, column 1 would be a length of 10, column 2 length of 10, column 3 length of 20, etc.
I don't want to use "" around the fields, and I don't want to use commas (or another character) to separate the fields.

Is this possible in Crystal Reports 8.5? I have tried the "Record Style (columns no spaces) option", but it seems to put some strange amounts of spaces between the fields. I have tried moving and resizing the fields on the report, but there are still some strange spaces between the fields in the exported file.

Any help would be appreciated. Thank you,
Marie

 

[kenhamady]

When I have had to do this I have created a long formula that has all of the fields in it (padded with spaces) and then use a TEXT export with no page header or footer. Usually this means using Landscape orientation to make sure you don't run out of room. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[DesertRay]

I am a novice at best, but have been trying to solve this for about 3 weeks including posting the same question here. This is what I finally found that worked. Select a fixed format font like Courier new. Set the size to 10.(it made a difference). Then size the field, based on the grid marks, to the number of positions that you want. Each grid mark is 1 position. If you want your first field to be 10, then make the field in the design area 10 grid marks long. How close or far away you set the next field doesn't seem to make any difference when you select Record Style (no spaces). I experimented with all of the different formats to no avail. Hope this helps.