"PaulQld" <PaulQld@discussions.microsoft.com> wrote in message
news:396E5C64-9423-4C00-BFDE-1D8837DEBE77@microsoft.com...
>I have a param'd stored procedure that returns a recordset.
>
> If I run the SP from Query Analyser the values in the recordset are as I
> expect them to be - Correct.
>
> If I run the SP from the Data Tab in RS , then randomly I will get a field
> value that
> has been ..
> 1: Rounded up eg: 59,270 becomes 59,300
> OR
> 2: Has something subtracted eg: 59,270 becomes 49,270
>
> The returned fields are Money. I have tried decimal but to no avail.
> The example above is random. There are no formulas that might affect the
> output
> of these fields.
>
> Note that I am only comparing the Data sources , the report is incorrect
> of
> course as a result and all calcs that rely on the fields are affected by
> the
> above problem, which throws the whole report into a state of inaccuracy.
>
> RS is running against a SQLServer 2000 db, SP3.
> RS is at SP1. RS is running on a different server to SQL.
>
> If you have experienced anything like this please respond to this post.
> Many
> thanks in advance.
>
> Paul
>
>
>
>
>

"Lev Semenets [MSFT]" wrote:

> Could you run Profiler to check if Report Designer calls stored procedure in
> same way QA does?
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "PaulQld" <PaulQld@discussions.microsoft.com> wrote in message
> news:396E5C64-9423-4C00-BFDE-1D8837DEBE77@microsoft.com...
> >I have a param'd stored procedure that returns a recordset.
> >
> > If I run the SP from Query Analyser the values in the recordset are as I
> > expect them to be - Correct.
> >
> > If I run the SP from the Data Tab in RS , then randomly I will get a field
> > value that
> > has been ..
> > 1: Rounded up eg: 59,270 becomes 59,300
> > OR
> > 2: Has something subtracted eg: 59,270 becomes 49,270
> >
> > The returned fields are Money. I have tried decimal but to no avail.
> > The example above is random. There are no formulas that might affect the
> > output
> > of these fields.
> >
> > Note that I am only comparing the Data sources , the report is incorrect
> > of
> > course as a result and all calcs that rely on the fields are affected by
> > the
> > above problem, which throws the whole report into a state of inaccuracy.
> >
> > RS is running against a SQLServer 2000 db, SP3.
> > RS is at SP1. RS is running on a different server to SQL.
> >
> > If you have experienced anything like this please respond to this post.
> > Many
> > thanks in advance.
> >
> > Paul
> >
> >
> >
> >
> >
>
>