By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

remove decimal from crystal report

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.