471,344 Members | 1,584 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,344 software developers and data experts.

Crystal Number Format Problem.

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.
Jul 21 '05 #1
3 2302
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.

Jul 21 '05 #2
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.
Jul 21 '05 #3
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.

Jul 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Colin Graham | last post: by
reply views Thread by Zoury | last post: by
4 posts views Thread by jaYPee | last post: by
3 posts views Thread by John H. | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.