Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Changes to preset forms Post Reply Post New Topic
Author Message
dagmar
Newbie
Newbie


Joined: 16 Jul 2007
Location: Canada
Online Status: Offline
Posts: 2
Quote dagmar Replybullet Topic: Changes to preset forms
    Posted: 16 Jul 2007 at 10:49am
I just received an update of Business Vision with Report Writer Crystal Reports 10 included.
 
I want to make a minor change to the Laser Paycheque form.  In a Label it has regular hours @ rate but the report rounds up the regular hours.  I need it to go to two decimal places.
 
Is there a quick & simple way to do this?  PS.. I have not have any Crystal report training but need to get paycheques out asap.  Thanks in advance.
 
This is what I get when I edit the label
WhilePrintingRecords;
NumberVar RegularTimeDollars;
NumberVar RegularTimeHours;
NumberVar RegularTimeRate;
if RegularTimeHours = 0
    //no regular hours
    then ""
else if RegularTimeHours * RegularTimeRate = RegularTimeDollars
    //regular hours all at one rate
    then "(" + Totext(RegularTimeHours, 0, "") + " hours at " + totext(RegularTimeRate, 2) + ")"
else //when more than one rate was applied
    "(" + Totext(RegularTimeHours, 0, "") + " hours at multiple rates)"

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 16 Jul 2007 at 11:09am
Swap out the 0 with a 2:
Totext(RegularTimeHours, 2, "")
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
dagmar
Newbie
Newbie


Joined: 16 Jul 2007
Location: Canada
Online Status: Offline
Posts: 2
Quote dagmar Replybullet Posted: 16 Jul 2007 at 12:44pm
Thank you so much.. you're a life saver. 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 16 Jul 2007 at 12:59pm
Glad to help. Links are always appreciated. 
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.031 seconds.