Focal Point
[solved] Values not showing as they should

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4197001136

May 28, 2013, 12:55 AM
FrankDutch
[solved] Values not showing as they should
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