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
> > > >
> > > >
> > >
> > >
> >
> >
>

Overflow error

Hi!

I created a VB6 program using MS Access DB and crystal reports 9. It works fine on WinXP, but I sometimes encounter an 'Overflow' error on Win98 SE.

For example, I have report A and B. When I start the program and immediately print report A, I encounter the error. But when I print report B first and then print report A, the errors gone. I think there's really no problem with the code...so what gives?

By the way, on some PCs with Win98, there's no problem too. Weird huh?

Thanks a lot!

This one's urgent...I'm too embarrassed already with the department using the program...I don't want them to think that I'm stupid or something hehe.Is there any link between those two reports?
Did you use any formula?|||Thanks for replying...

Regarding your question, the two reports are not linked...the data are also gathered from different tables, that is, I do all the necessary computations first and then load up a table for specific reports wherein data for the report will be gathered.