Print Page | Close Window

boolean is required

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=7424
Printed Date: 03 May 2024 at 4:19am


Topic: boolean is required
Posted By: opinky
Subject: boolean is required
Date Posted: 19 Aug 2009 at 9:02am
I am trying to format this field so it has leading zeros, when I use the formula below i get the boolean is required. What am I missing.
 
ToText(ToNumber({PYMT.DOC_AMT}),'000000000000')
 
Thanks
Pinky


-------------
Thanks,
Pinky


Replies:
Posted By: DBlank
Date Posted: 19 Aug 2009 at 10:45am
Are you using this in Crystal Syntax or Basic Syntax?

Posted By: opinky
Date Posted: 19 Aug 2009 at 10:49am

Crystal Syntax



-------------
Thanks,
Pinky

Posted By: DBlank
Date Posted: 19 Aug 2009 at 10:52am
Where exactly in Crystal are you using the formula?

Posted By: opinky
Date Posted: 19 Aug 2009 at 11:02am
In the report footer I am trying to sum the field and make it come out with the leading zero's . like if the sum amount is 7325.00 i need it to read
000000732500
 
I have the field where it is summing already.


-------------
Thanks,
Pinky

Posted By: DBlank
Date Posted: 19 Aug 2009 at 11:10am
Does this work...
Create a formula field as "ConvertedSum" with the formulas of:
 
ToText((SUM({table.fieldtosum})*100),'000000000000')
 
Place the formula field in the report footer.

Posted By: opinky
Date Posted: 19 Aug 2009 at 12:46pm
That worked good the only thing is it has a $ then all the zero's


-------------
Thanks,
Pinky

Posted By: DBlank
Date Posted: 19 Aug 2009 at 1:00pm
Sorry, did not know it was a currency value.
ToText(tonumber((SUM(({table.fieldtosum}))*100)),'000000000000')

Posted By: opinky
Date Posted: 19 Aug 2009 at 1:06pm
Thank You so much you have been a great help!

-------------
Thanks,
Pinky


Print Page | Close Window