PDFTable showing decimals to 4 places

[BigAl1958]

I have a PDFTable that has a datasource from SQLServer in VB - when I produce the PDF it shows ALL decimals with 4 digits after the decimal point, how do I get it to only show 2?

[Lisa.Li]

Hello,

Thanks for your inquiry.
Since all the data and graphics of PDF are drawn on canvas. There is no direct way of setting to show decimals with 2 digits, it only draws as the original data. Thus, as for your situation, you could firstly convert your original data with 2 digits and then draw them into PDF. If there is any other question, just feel free to contact us.

Sincerely,
Lisa
E-iceblue support team

[BigAl1958]

Ok - the data I was extracted had the values showing as xx.xxD and so appeared to be 2 decimal places - on further investigation in Debug it show xx.xxD but if I used .toString on the values it showed 4 digits - the problem was the fields were defined as Money on the database and presumably e-spire effectively used the .tostring and so got 4 dp.

I solved the problem by changing all the fields to Decimal(8,2)

[Lisa.Li]

Hello,

Glad to hear that you solved the issue. If you encounter any issue related to our products in the future, just feel free to contact us.
Wish you all the best!

Sincerely,
Lisa
E-iceblue support team