473,406 Members | 2,847 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,406 software developers and data experts.

remove decimal from crystal report

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

Crystal Reports automatically convert the 1.5 to 2. in this case my
report display this data.

2
2
2
3

anyone know how to display data in a report without the use of crystal
report's own formating?
Nov 21 '05 #1
4 12152
This is a vb.net group but if you in crystal reports right click the field
then choose format field and then the number tap I think you should find
your answer there

hth

Greetz Peter

"jaYPee" <hi******@yahoo.com> wrote in message
news:36********************************@4ax.com...
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

Crystal Reports automatically convert the 1.5 to 2. in this case my
report display this data.

2
2
2
3

anyone know how to display data in a report without the use of crystal
report's own formating?

Nov 21 '05 #2
This is a vb.net group but if you in crystal reports right click the field
then choose format field and then the number tap I think you should find
your answer there

hth

Greetz Peter

"jaYPee" <hi******@yahoo.com> wrote in message
news:36********************************@4ax.com...
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

Crystal Reports automatically convert the 1.5 to 2. in this case my
report display this data.

2
2
2
3

anyone know how to display data in a report without the use of crystal
report's own formating?

Nov 21 '05 #3
Yah I go to the format menu but don't know what formula should I use.
I don't want to use the formating of crystal reports so that it must
be based on the record on my table.

thanks
On Fri, 28 Jan 2005 09:34:00 +0100, "Peter Proost"
<pp*****@nospam.hotmail.com> wrote:
This is a vb.net group but if you in crystal reports right click the field
then choose format field and then the number tap I think you should find
your answer there

hth

Greetz Peter

"jaYPee" <hi******@yahoo.com> wrote in message
news:36********************************@4ax.com.. .
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

Crystal Reports automatically convert the 1.5 to 2. in this case my
report display this data.

2
2
2
3

anyone know how to display data in a report without the use of crystal
report's own formating?


Nov 21 '05 #4
Yah I go to the format menu but don't know what formula should I use.
I don't want to use the formating of crystal reports so that it must
be based on the record on my table.

thanks
On Fri, 28 Jan 2005 09:34:00 +0100, "Peter Proost"
<pp*****@nospam.hotmail.com> wrote:
This is a vb.net group but if you in crystal reports right click the field
then choose format field and then the number tap I think you should find
your answer there

hth

Greetz Peter

"jaYPee" <hi******@yahoo.com> wrote in message
news:36********************************@4ax.com.. .
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

Crystal Reports automatically convert the 1.5 to 2. in this case my
report display this data.

2
2
2
3

anyone know how to display data in a report without the use of crystal
report's own formating?


Nov 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Stephan | last post by:
Hi, I'm using Visual Studio 2003 (C#) with the integrated Crystal Report software and have the following question: How can I assign a value (string) to an unbound (string) field in Crystal...
0
by: V.Boomessh | last post by:
Hai all I am creating an VB.NET application which has some reporting involved. i use Crystal report for VS.NET to create the report I have designed the report(rpt file) by making a connection...
0
by: John H. | last post by:
Hi, If set a records using the Crystal Report method 'Report.Database.Tables.SetDataSource(dataTable)', the Crystal Report Net 2003 do not release the system resources after executes the...
0
by: Colin Graham | last post by:
I have built a crystal report in Visual studio 2003 and i am now able to display the report on my screen using a .net crystal report viewer. The problem that i have is that the crystal report is...
5
by: Damir | last post by:
Please I need help and dont know where to post the question..... So I am making a small asp.net application and need to generate a crystal report with one image that changes depending of some data....
0
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
1
by: Roger | last post by:
Hello all Haven't worked with Crystal since the VB 4 days. Now for the first time I'm trying to create a report in a .net/vb project using SQL 2000 for the Database. When I add the Crystal...
1
by: Shailja | last post by:
Hi, How to do alignment of decimal point in Crystal Report? When I open the crystal report, numbers display in following manner: 100.16 10.16 Instead, if second number consists of 2 digits...
3
by: acextreme | last post by:
Hi all, I have a big problem when I try to export from Crystal Report 8.5 in .pdf from VB6. I use a database made in SQL Server 2000. The problem is that all the decimal fields in database are...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.