Overflow or underflow in the arithmetric operation

Hello,
Has anyone encounter this error message when they try to preview the report.
I create a simple report with an external ODBC data source. The report has
a list of name (string) and values (double).
When I try to preview it keep on giving this error. I has no clue what is
causing this. I'ved try this ODBC on other application they all work fines.
It is just this new MSRS I am having trouble with.
I am using VS 2003.Net with MSRS service patch 1.
-rsUsually this is because on an expression being used that is doing math. If
you use an iif function you need to be careful because every part of it
(both true and false) get evaluated which can cause overflow, divide by 0
type of errors.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rs90144" <rs90144@.hotmail.com> wrote in message
news:%23n6J0kM$EHA.600@.TK2MSFTNGP09.phx.gbl...
> Hello,
> Has anyone encounter this error message when they try to preview the
report.
> I create a simple report with an external ODBC data source. The report
has
> a list of name (string) and values (double).
> When I try to preview it keep on giving this error. I has no clue what is
> causing this. I'ved try this ODBC on other application they all work
fines.
> It is just this new MSRS I am having trouble with.
> I am using VS 2003.Net with MSRS service patch 1.
> -rs
>|||The message sound like some kind of math was done. But in the report there
are
no IIF funcatons or any other funcation, just a simple list of value from
the ODBC driver. That's why it is so strange.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:#VtBMFN$EHA.2804@.TK2MSFTNGP15.phx.gbl...
> Usually this is because on an expression being used that is doing math. If
> you use an iif function you need to be careful because every part of it
> (both true and false) get evaluated which can cause overflow, divide by 0
> type of errors.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "rs90144" <rs90144@.hotmail.com> wrote in message
> news:%23n6J0kM$EHA.600@.TK2MSFTNGP09.phx.gbl...
> > Hello,
> >
> > Has anyone encounter this error message when they try to preview the
> report.
> > I create a simple report with an external ODBC data source. The report
> has
> > a list of name (string) and values (double).
> > When I try to preview it keep on giving this error. I has no clue what
is
> > causing this. I'ved try this ODBC on other application they all work
> fines.
> > It is just this new MSRS I am having trouble with.
> > I am using VS 2003.Net with MSRS service patch 1.
> >
> > -rs
> >
> >
>|||What is the ODBC driver are you using (what are you reporting against: SQL
Server, Sybase, DB2, Oracle, etc?)
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rs90144" <rs90144@.hotmail.com> wrote in message
news:%23WCiwTN$EHA.3124@.TK2MSFTNGP11.phx.gbl...
> The message sound like some kind of math was done. But in the report there
> are
> no IIF funcatons or any other funcation, just a simple list of value from
> the ODBC driver. That's why it is so strange.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:#VtBMFN$EHA.2804@.TK2MSFTNGP15.phx.gbl...
> > Usually this is because on an expression being used that is doing math.
If
> > you use an iif function you need to be careful because every part of it
> > (both true and false) get evaluated which can cause overflow, divide by
0
> > type of errors.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "rs90144" <rs90144@.hotmail.com> wrote in message
> > news:%23n6J0kM$EHA.600@.TK2MSFTNGP09.phx.gbl...
> > > Hello,
> > >
> > > Has anyone encounter this error message when they try to preview the
> > report.
> > > I create a simple report with an external ODBC data source. The
report
> > has
> > > a list of name (string) and values (double).
> > > When I try to preview it keep on giving this error. I has no clue
what
> is
> > > causing this. I'ved try this ODBC on other application they all work
> > fines.
> > > It is just this new MSRS I am having trouble with.
> > > I am using VS 2003.Net with MSRS service patch 1.
> > >
> > > -rs
> > >
> > >
> >
> >
>|||I am using an in-house ODBC driver (Level-2.5 compliance). We tested this
ODBC driver with Crystal, Business Object, Excel etc. and even with
Microsoft Analysis Service and all works fine. It is just this new Reporting
Service that is giving us headache.
Any claues.
-rs
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eHQlidN$EHA.3368@.TK2MSFTNGP10.phx.gbl...
> What is the ODBC driver are you using (what are you reporting against: SQL
> Server, Sybase, DB2, Oracle, etc?)
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "rs90144" <rs90144@.hotmail.com> wrote in message
> news:%23WCiwTN$EHA.3124@.TK2MSFTNGP11.phx.gbl...
> > The message sound like some kind of math was done. But in the report
there
> > are
> > no IIF funcatons or any other funcation, just a simple list of value
from
> > the ODBC driver. That's why it is so strange.
> >
> >
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:#VtBMFN$EHA.2804@.TK2MSFTNGP15.phx.gbl...
> > > Usually this is because on an expression being used that is doing
math.
> If
> > > you use an iif function you need to be careful because every part of
it
> > > (both true and false) get evaluated which can cause overflow, divide
by
> 0
> > > type of errors.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "rs90144" <rs90144@.hotmail.com> wrote in message
> > > news:%23n6J0kM$EHA.600@.TK2MSFTNGP09.phx.gbl...
> > > > Hello,
> > > >
> > > > Has anyone encounter this error message when they try to preview the
> > > report.
> > > > I create a simple report with an external ODBC data source. The
> report
> > > has
> > > > a list of name (string) and values (double).
> > > > When I try to preview it keep on giving this error. I has no clue
> what
> > is
> > > > causing this. I'ved try this ODBC on other application they all work
> > > fines.
> > > > It is just this new MSRS I am having trouble with.
> > > > I am using VS 2003.Net with MSRS service patch 1.
> > > >
> > > > -rs
> > > >
> > > >
> > >
> > >
> >
> >
>