Crystal Thick Client: 11.5.10.1263

I am using an Oracle query as a Crystal Command, and the data looks good with exception that it is cutting off any trailing spaces on my data fields.

When I run the same query in TOra the trailing spaces are there.

I need these trailing spaces for consistency with a legacy report.

Any idea why they're being removed automatically?

I verified "Can Grow" is checked on the field I am using.

I'm sure I could add the missing spaces back in with a LEN subtraction calculation, but that would require I infer what the field length should be since LEN also auto-trims, and an upgrade could then potentially break the report if the field length were to change.


Edited by Erik - 07 Jul 2014 at 1:28pm