Cost Of Item 1

[midgette]

Sorry I forgot to put a subject.

Is there a special string to include a $ value into a Crystal Report.

The Informtion is being taken from the Heat SQL database.


Thanks

 

[MJRBIM]

As long as it's a NUMBER field you are reporting on, just highlight the field in the DETAIL and click on the CURRENCY tool "$" in the Expert Tools Bar.

If you want to use a formula, you will have to convert the number into a string use this formula

"$" + ToText({TABLE.NUMBERfield })

 

[scottostanek]

>As long as it's a NUMBER field you are reporting on, just highlight the field in the DETAIL and click on the CURRENCY tool "$" in the Expert Tools Bar.

I also use this to handle % (percentages) as there is an option to change the default currency symbol, as well as where it prints (after in this case).