Printable View
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.
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.
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 ?