Figures are automatically being rounded. For example, 26.25 becomes 26.00 while 89.74 becomes 89.00. The format of the column is general and there's no function attached to the figures. The same report can be run on a different computer with both the dollars and cents showing, correctly without the rounding. I believe this has something to do with an impromptu config file, perhaps the locale. Does anyone know how to stop the automatic rounding from occurring?
Thanks
Is Impromptu installed separately on the computers, or is it run from a network share? If it is installed on each computer then you have to make sure each computer is configured the same.
This option can be specified in the menu under the Tools/Options... configurations. Open the "Data Format" tab and check what is the "Positive" option for the "Numeric" Data Type box. Change the option from "General" to "Number" or "0.00" and see if that helps.
Impromptu is installed as standalone on each machine. Your suggestion did not work. I believe I tried everything possible within Impromptu to rectify this issue, but nothing worked. That's why I believe it's some ini or locale file controlling the rounding, but I'm not sure which one.
I discovered that he report is running correctly on machines with Oracle ODBC Driver V8.01.06.00, but the cents are getting zeroed on machines with Oracle ODBC Driver V10.02.00.01. The newer driver has a numeric setting of use windows regional, oracle NLS, or US. How do I force impromptu to use the windows regional. The newer driver defaults to oracle NLS.