473,241 Members | 4,070 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 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 2402
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Colin Graham | last post by:
I have recently created a report in crystal(10) linking to a dataset as the datasource. I notice however that the fields available in the report all have STRING format and therefore i cannot change...
0
by: Zoury | last post by:
Hi there ! :O) I'm having a two strange behaviors with Crystal Report which seems to have the same cause.. All the fields used in the reports comes from some SQL Server views. *** 1st...
6
by: Robin Cushman | last post by:
Hi all, I need some help -- I'm working with an A2K database, using DAO, and am trying to read records into a Crystal Report and then export it to a folder on our network as an Excel...
19
by: LP | last post by:
I am using (trying to) CR version XI, cascading parameters feature works it asks user to enter params. But if page is resubmitted. It prompts for params again. I did set...
4
by: jaYPee | last post by:
I have a report created in crystal report. My problem is on how can I remove the decimal point without converting the value. say for example if I have this data: Unit 2 1.5 2 3
3
by: John H. | last post by:
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...
4
by: Rodo | last post by:
Hi all, I'm new to this whole thing. I have a bunch of text files that are created by a software at work that keeps info one of our products. Each unit being calibrated gets a "record" (track by...
0
by: Brad King | last post by:
Hello all, I am going to describe my specific problem. Also, I can program in C++ & Java although I am a little rusty. I took both classes in order to get my MIS degree but have not touched them...
2
Pittaman
by: Pittaman | last post by:
Hello I am creating some crystal reports (for visual studio 2005) based on the content of certain .NET objects. I'm doing this in .NET 2.0. For one of them I'm using a Cross-table to summarize...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...

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.