I have the problem that when I build a new report in DS, some of my fields automatically get a fixed length.
These fields have a format of AnV (A50V or A100V).
When I remove the fixed length settings, save the report and run it, I sometimes see the result still with that fixed length. How can I avoid this?

Hi FrankDutch,

Has this issue been resolved?

I asked an internal resource and was suggested that you may need to change the MASTER and/or ACCESS file descriptions for this to take effect.

Hope this helps.

Cheers,

Kerry

In 71, VARCHAR fields are mapped to the AnV format. To switch back to the behavior in older releases, add the following to the global profile or edasprof.prf file of the reporting server:
ENGINE SQL SET VARCHAR OFF

for example
ENGINE SQLORA SET VARCHAR OFF

remember that this will affect all synonyms created on the server

great, that is worth trying...
I will let you know if it worked next week!
have a nice weekend.