Fixed Width Text File

[mdtimo]

I have a report that I export to a fixed width text file. For years it worked fine and then today it started to add a blank space before it displayed the data in the report. Any ideas on what could have caused this?

We didn't change versions of Crystal and notepad is the same version as well.

 

[mdtimo]

I'll add a little more detail.

If I have a report with just one text box and this column is on the far left of the report and then I export it to a text file it adds a single space to the left of the text file. Any ideas?

 

[pgtek]

hi
read this article

http://support.crystaldecisions.com/library/kbase/articles/c2005609.asp

pgtek

 

[mdtimo]

I used the same logic that you refered to in my report but instead of displaying data in the first space of each line it has a blank space then the data. It is happening on both 8.0 and 8.5.

For example

_08122003
with the underscore representing a blank space.

It should display
08122003

 

[synapsevampire]

I'd guess that the data or the database or the connectivity might have changed, since you haven't upgraded ANYTHING, right?

Try applying the hotfixes from Crystal, alternatively try trimming the field in a formula.

http://support.crystaldecisions.com/fix/hot/si75/?ref=default.asp_selectlist

-k