Problem with numeric fields

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
apowell
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Problem with numeric fields

Post by apowell » Wed Aug 27, 2008 8:12 am

I am running a report that has several numeric fields. I am using R&R for Windows, SQL Edition, Version 12, Build 12.1.001. The results for these fields are not displaying properly. Instead, if the number is greater than 999 or less than -999 the result is -1. Number in between this range display correctly. When I look at each field name it says for example: pd_grc_bgt.n_totdc: (Numeric/11.0)(DB: Code 3). What does the DB: Code 3 mean?____Thanks for any help/insight you can give!____A. Powell

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Problem with numeric fields

Post by kfleming » Thu Aug 28, 2008 8:31 am

What ODBC driver are you using?____Kathleen__R&R Support

apowell
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Problem with numeric fields

Post by apowell » Thu Aug 28, 2008 9:46 am

We are using SQL Server driver.

Post Reply