Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: ?? on getting just interger Post Reply Post New Topic
Author Message
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Topic: ?? on getting just interger
    Posted: 17 Jul 2012 at 5:17am
Hi,
 
I have a parameter which is a number range 
user puts in a  min and max
I wanted to display the min and max on the footer
I wanted to display as 1 to 99
and it displays as 1.00 to 99.00
 
 
"Service Age From: " & Minimum ( {?Service Age} ) &
" To: " +{@maxser}
 
where maxser =
 
if Maximum({?Service Age})=0 then 'No Limit' else totext(Maximum ({?Service Age}))
 
How do I drop the decimals?
 
Thx
 
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 17 Jul 2012 at 5:33am
Not sure which version of CR you are using, but in most versions there is a increase decimals and decrease decimals icon, or you can format the number to not display the decimal. 

I hope this helps.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Jul 2012 at 5:37am
also adjust your totext() formula to drop the decimals
if Maximum({?Service Age})=0 then 'No Limit' else totext(Maximum ({?Service Age},0,""))
 
IP IP Logged
jbalbo
Senior Member
Senior Member
Avatar

Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
Quote jbalbo Replybullet Posted: 17 Jul 2012 at 5:38am

Thanks for the info,

The value is pulled from a paramter.. sorry I didn't mention thats.
 
I did use this and it seemd to work..
 
if Maximum({?Service Age})=0 then 'No Limit' else totext(Maximum ({?Service Age}),0)
 
the totext (x,y) where y are the number of decimals..
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.018 seconds.