Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number formats - Crystal 8.0

Status
Not open for further replies.

HelpPlease

Programmer
Dec 15, 2000
11
US
Hello, I have a report that is basically a concatenation of strings. The string contains formulas for date values.The formula cast the date to a string, seperates month,day, and year, and concatenates them to achieve the format needed.


Problem:
When the report is opened from any computer other than the development machine, the format changes.

Date: 06/06/2001
Format needed: 20010606

Development Machine: 20010606
Any other machine: 2,001.006.006.00

It formats the numbers with a thousand seperator and a decimal. From the test machine(non-dev), I can change the format for number fields to not include a thousand seperator or decimal. The next time I display the report, it comes up correct.

Question:
I don't want to go to each users machine a make this adjustment. Is there anything I can do on the development side that will allow the correct formats to be displayed?

Thank you for your help,
HelpPlease
 
You can format the field in the report to have the correct formatting, rather than using the default formatting (and having to change/maintain the default formatting for each machine). Right click on the field, choose format, click on the custom button, and go from there. Malcolm Wynden
Authorized Crystal Engineer
malcolm@wynden.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top