Crystal Number Format Problem.

[John H.]

Hi,

Why if set a DataTable in Crystal Report Net Table with method
SetDataSource, 'ReportDocument.SetDataSource(oDataTable)', lost the Number
and Currency format with the decimal digits and Currency symbol?

How do you correct this problem?

Thanks.

[Bernie Yaeger]

Hi John,

AFAIK, crystal recognizes the base table types, not their format, regardless
of the datasource. You will have to format the numbers inside crystal,
using the format option (right click the column entry on the designer and go
from there.

HTH,

Bernie Yaeger

"John H." <jo*****@hotmail.com> wrote in message
news:uN*************@TK2MSFTNGP15.phx.gbl...

Hi,

Why if set a DataTable in Crystal Report Net Table with method
SetDataSource, 'ReportDocument.SetDataSource(oDataTable)', lost the
Number and Currency format with the decimal digits and Currency symbol?

How do you correct this problem?

Thanks.

[John H.]

Thank you from the answer Bernie Yaeger , but the format is in the Crystal
Report Details Field Currency Format and lost the Currency Symbol and the
decimal digits.

For Example, field is SQLServer money type and it is in the crystal detail
section and the format, in the crystal, is display currency symbol and 3
decimal digits, after set the datatable with
'ReportDocument.SetDataSource(oDataTable)' the field displays with the
regional settings default number format.

Thanks again.

[Bernie Yaeger]

Hi John,

Sorry; I didn't understand the issue. Can't think of why the format would
be lost, but I'll test a few things to see if I can come up with a solution.

Bernie

"John H." <jo*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Thank you from the answer Bernie Yaeger , but the format is in the Crystal
Report Details Field Currency Format and lost the Currency Symbol and the
decimal digits.

For Example, field is SQLServer money type and it is in the crystal detail
section and the format, in the crystal, is display currency symbol and 3
decimal digits, after set the datatable with
'ReportDocument.SetDataSource(oDataTable)' the field displays with the
regional settings default number format.

Thanks again.