Results 1 to 3 of 3

Thread: format currency

  1. #1

    Thread Starter
    Lively Member
    Join Date
    May 2010
    Posts
    80

    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.

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    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.

  3. #3

    Thread Starter
    Lively Member
    Join Date
    May 2010
    Posts
    80

    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
  •  



Click Here to Expand Forum to Full Width