incorrect value

Hi,
I'm using crystal reports with firebird database. I installed the firebird ODBC Driver and I
created a DSN connection.
I've in my table a field of type number(15,2) and when I add it in the Crystal report a
incorret value is displayed.
Ex:
Table value field 5,45 and is displayed 0,05 int the crystal report.
The firebird dont have currency type.
number type only.

How I can do for the crystal report to use it number as currencey?

Please, help me.Hi
I dont know about the firebird database.

but please try to insert the value on the filed

like 547 without using comma

regards

Inconsisten Crystal Report

Hiya,

Been putting a report together in Crystal Reports X, and its giving inconsisten results.

I have 3 charts that are being created over a set of data, 2 are fine, but 1 is being inconsistent.

Its using a formula with a global array to store sales figures for the next 12 months (its something with the dataset), doing a bunch of calcs for current months sales, and rolling those figures forwards.

When you first run the report, it comes up with a set of values that bear no relation to the actual data.

If you then go in and just add a blank line to the formula and refresh it, the report runs exactly as expected.

Very strange, and totally repeatable, kinda clueless on what to do with it.Can you post the formula you used?
Also make sure you verify database everytime the table schema changes