Problem export to PDF format

[alvintse]

Hi,
I have a report with CR9, the data from SQL server. The layout is looks perfect on preview, everything aligned. However, when I export the report in pdf format, one of the field always shift to right about 7 characters in spaces. I have tried the lock size/position tab in crystal reports, put the data inside a textbox, trim the data ... anything I can think of. By the way, the datatype for that field is Currency.

Thanks.

 

[synapsevampire]

Hmmm, if all else fails, try converting the datatype:

totext({table.field},2,",&quot

Also make suer that you apply the latest service pack, it may help.

-k

 

[alvintse]

Hi,
I have installed the CR SP2 and tried converting the data to different datatype, place the filed at different position within the report, still not working.

Really need help.

Thanks.