HelpPlease
Programmer
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
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