Export to text creates extra line

[Former Member]

I've created a number of fixed width extract reports that will be used to upload data into another system. The files, in general, are fine, however Crystal Reports 2008 is adding an extra line to the end of the file. This is causing the upload to fail.

I've created several. extract reports before, so I reviewed a sample extract from a report I created in Crystal Reports XI R2 and it, too, had the same issue.

Googling indicates that others have had the same issue, but I have yet to find a resolution to the problem.

Has anybody else encountered this and do you know how to resolve the issue?

Thank you, Kurt

[ido_millet · Accepted solution]

Hi Kurt,

In my scheduler app I have a command line option to remove (or replace characters) in the resulting export file. This was developed for exactly that reason (so there is a special option to remove/replace only the last character in the file).

You can develop the same approach. Alternatively, there are more direct upload options (the export can go directly into a database table).

hth,

- Ido

[Former Member · Accepted solution]

Hi Ido! So this is where you've been hiding! It's been too long since we've had a chance to get together.

Unfortunately, a 3rd party app is probably out of the question for my client. If I'm not able to find a solution through Crystal Reports directly, I may need to consider generating the extract straight out of SQL, although that'd be a shame, since it works beautifully in Crystal Reports 2008, minus the extra line issue.