Print Page | Close Window

Formatting Currency Field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8816
Printed Date: 04 May 2024 at 4:47pm


Topic: Formatting Currency Field
Posted By: huddy33
Subject: Formatting Currency Field
Date Posted: 06 Jan 2010 at 10:58am
I have a currency field placed in a report.  The user wants to see the dollar signs lined up on the left and then the decimal places lined up to give the view of right alignment on that side.  I have tried justifying the field, but all I get is the left side lined up and the right side is off.  I am stumped on how to do this. 

Any help is appreciated!


Replies:
Posted By: FrnhtGLI
Date Posted: 07 Jan 2010 at 5:28am
I believe you can just expand the field a bit and right align it. That will take care of the decimal part.
 
For the dollar sign, right-click the field ->Format Field -> Number Tab. Check Display Currency Symbol and check Fixed. That will left justify the dollar sign.

Posted By: huddy33
Date Posted: 07 Jan 2010 at 8:09am
This is perfect, thank you!


Print Page | Close Window