cancel
Showing results for 
Search instead for 
Did you mean: 

Data truncated on reports

Former Member
0 Kudos

Post Author: Pertti Suhonen

CA Forum: Crystal Reports

We have a Crystal Reports Server (XI R2) running on Linux. The data to report is located in PostgreSQL running on an another Linux and unixODBC is used.

The problem is that running reports on InfoView all text strings are truncated. The last letter is missing. And for example if we have a field, that is in the business view concatenated from two separate fields, both strings are truncated. 'John Smith' is displayed as 'Joh Smit'.

Urgent help is needed! Thank You in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Pertti Suhonen,

Could you tell me how you managed to configure the connection to PostgreSQL on Linux? Or where can I get information about this configuration?

Regards,

Newton Ahagon

Former Member
0 Kudos

Post Author: jpierson

CA Forum: Crystal Reports

I've seen similar problems when Crystal seems to think that the field size should be a specific size. For example I had a case where I was using a formula field that had two optional results in an IF ELSE expression but I kept on getting wacky results. The solution for me ended up being to set a local variable to the result and then at the end of the formula return the value of that variable as the formula result. Maybe it's possible you are using a formala field for both of these names and having a similar problem to what I had or maybe your fields are specificly sized strings and in that case maybe modifying your source or re-running verify database would fix the problem.