number rounding to ###.01

[LidoDeJesolo]

Hi all

I've just installed Crystal v10 and opened up a report I created in v8.5

In this report I had a formula that converted a numerical field to a name.

ie... if <numericalfield>=3 then "Bobby Brown" else....

etc..

When I converted to v10, this formula stopped working. I put the numerical field into the report and discovered that instead of showing "3" as the value, it was showing "3.01".

What has happened!? Any clues?

The data is from a SQL Server 2000 DB which hasn't been altered at all.

Thanks



Lido
Development & Reporting
UK

 

[bdreed35]

I seem to recall reading a different post that had a similar problem.

I think that the problem was resolved by changed the databsae driver that was used to connect to SQL Server. Try using the CR provided ODBC driver to connect.

~Brian

 

[bdreed35]

I meant to say that you want to use the CR provided SQL Server ODBC driver.

~Brian

 

[LidoDeJesolo]

Sorry about replying so late. I've been in hospital!

Where can I find the CR provided SQL Server ODBC Driver? I'm still struggling with this.

Lido
Development & Reporting
UK

 

[GJParker]

Lido

What is the value in the database ? is it 3 or is it 3.01 ?

why not try int(<numericalfield>) = 3

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[LidoDeJesolo]

The value in the database is 3.00 and v8.5 had no problem showing this value correctly.

I was hoping I could run the reports in v10 without having to change any formulas. But maybe that isn't the case.

Lido
Development & Reporting
UK