We recently upgraded from 7.7.3 to 7.7.5 Besides a lot of unexpected and unwanted changes I have the following strange behaviour on one SQL table
We have a MFD that says ....USAGE=D15.2, ACTUAL=P8, ...
For a lot of fields.
But all fields from this database show like 15,123.00 even if the database has the correct value of 15,122.54 or 15,123.12 So all fields are rounded in my reports
And it only does for one SQL table that existed before the upgrade but that I did recreate.
Could it be something that needs to be set in the ACX ?This message has been edited. Last edited by: FrankDutch,
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
May 28, 2013, 08:51 AM
jgelona
When we create masters, I have never seen the format types mixed.
We could have D15.2 and D8 or P15.2 and P8.
I would suggest making the format types consistent.
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
May 28, 2013, 01:25 PM
FrankDutch
Jgelona that was indeed the problem. Sometimes you overlook the most easy solution.
Thanks
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7