Impromptu SQL Server numeric data display issue

[semby]

Has anyone seen or resolved the following problem. Cognos support is dishing it off saying its not thier fault microsoft's odbc driver does not work.

odbc driver for sql server version 2000.81.9031.14 (ships with sql server 2000 sp3)

what's happening is that my table has a numeric(10,2) field, extended_cost. A sql query analyzer query will show
sku 1234 ext_cost 750.00
sku 4567 ext cost 1249.99

impromptu will show:
sku 1234 ext_cost 750.00
sku 4567 ext cost 1.24

any ideas on how to get around this? ODBC is the only connection option allowed to this db.

 

[semby]

I should also add, that this is the second instance of sql server on a the server.

 

[griffindm]

semby,

Never heard of this one before. If you pull data into Excel from the ODBC source, using Get External Data, do the numbers come in rounded as well? If so, Cognos support might be right. I've written a number of reports through the MS ODBC driver and don't remember this problem. Please get back with your version of Impromptu and MDAC / ODBC driver.

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com