Displaying field values with non-printable characters

[cfriedberg]

I have a report (CR 8.0) that uses a SQL 2000 stored procedure. In the past this report worked. I recreated the stored procedure to get new data and tried run the report again. The problem is that some of the characters in specific fields are not readable. One value is expressed as a natural log value: 1.36e+036 and a character field becomes little squares.

Any help please?

Carolyn

 

[Ngolem]

does wrapping the field in a Trim help? Jim Broadbent

 

[cfriedberg]

That did not help either. I rebuilt the report and copied the items over one by one and there seemed to be no trouble. I still can not figure out why there seems to be the corruption.

Carolyn