Crystal Number Format Problem.

  • Thread starter Thread starter John H.
  • Start date Start date
J

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.
 
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
 
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.
 
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
 
Back
Top