Question Locked

Crystal Reports XI: Money values appear as "Zeros"

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have a problem using Crystal Reports XI, VB and .NET 1.1 whereby a Report returning money values will return just 0.00 instead of the actual value held on the database. Database is Ingres 2.6 accessed via Ingres ODBC, but our tests show that the correct values are returned via the ODBC.
To make it worse, the same report DOES return the correct values on some Win XP Pro workstations and W2K3 Servers, eg. it works correctly on one of our 2 Metaframe Servers, but not on the other.
Has anyone seen this problem before, or have suggestions as to what causes it?
Many Thanks, Phil

4 replies

by dr dij

I'm pretty good with crystal but this sounds like could be corruption somewhere else; or problem with odbc drivers..

I guess there's some things you could try:
on a copy of the report, try changing the formatting values.
Also try exporting the report to spreadsheet
and also to delimited file. look at the output by opening file in word; if you rename tab delim to .xls you can also click and open immed in xl.
and finally, when I'm developing xtal reports, I often check the source data files using access since I don't have to grab whole file to get first screen. setup a link to the file: file | get external data | link tables | ODBC as source type
| machine data source, select the driver and add a few of the tables from your database that you need.

Do a quick query in design mode, right click on key links and select right type of join.

then drop a few of the fields you need into the grid below and see if get same problem.

these things might help you narrow down what is happening

also, using something like WinSQL (free for lite vsn) browse the database table defs for source data and see what type of data the fields defined as. Maybe there's some type of data that it returns the ODBC drives sometimes have probs with. I.e. there are usually several types of numeric fields; integer, float. long, short, fat, wide... :)

by hudson

Many Thanks Dr Dij.
We tried all the things that you suggested but to no avail. The data coming from the database is corrrectly passed over via the ODBC, and the table field definitions are all correct.
On Friday we installed the Report on a Win XP sp2 Notebook and the money values in the report are all correct. At the same time we installed on a Win XP sp2 PC and here, for the same report, same database tables, the money values are all 0.00.
It is very definitely something in the environment... the fact that the report works OK on other Win XP sp2 PCs, and also on other W2K3 Servers means that the report itself must be correct.
It seems that on certain Windows configurations or application mix the money value is being interpreted somewhere as zero.
Many Thanks for your help. If / when we find the cause I will post it here.
Best Regards, Phil

by hudson

In case anyone else may hit the same problem, Ingres Corp identified the cause of the problem as in version 3.50 of the Ingres ODBC driver, and have issued patch 11389 which resolves the issue.
The patch can be obtained by request from Ingres or via their ftp site.
Best Regards,
Phil

This discussion is closed to new replies.