-
Aug 13th, 2010, 04:35 AM
#1
Thread Starter
Lively Member
format currency
I am using CR11. I have a field that is populated by a database "jobtot1". I need it currency formatted. Every thing I have read tells me to right click the field and then go into the set up and select currency. I don't have any buttons or tabs anywhere that will allow me to format to anything. Is there a short simple script I can put in when the page loads that will format currency, same as in vb6.
-
Aug 13th, 2010, 08:22 AM
#2
Re: format currency
What is the datatype of the JobTot1 field? Based on what you describe it doesn't seem to be numeric as Crystal only shows the tab you want for numeric fields.
Create a Formula that converts the JobTot1 field, place the Formula on the report and try the formatting again.
-
Aug 13th, 2010, 07:32 PM
#3
Thread Starter
Lively Member
Re: format currency
The field "jobtot1" is a field from and excel db that I drag and drop on the form. You say create a formula that converts the field "jobtot1" field. You then place it on the report.
OK what is the formula ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|