Data on report different than what is in result set from stored pr

I am running my report in the IDE. When I execute the stored proc from the
data tab, the result set has the correct data. When I Preview the report,
the data on the report is different from what is in the result set. I have
made sure I used the same data in the report parameters that I used in the
query parameters. What causes this problem?
Thanks.GO to the properties of the field... It is probably set as a "general',
change the property to date, and set the format... that should fix your
problem
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:BACEB8DD-D958-479D-A5B8-F2FDA24C085E@.microsoft.com...
>I am running my report in the IDE. When I execute the stored proc from the
> data tab, the result set has the correct data. When I Preview the report,
> the data on the report is different from what is in the result set. I
> have
> made sure I used the same data in the report parameters that I used in the
> query parameters. What causes this problem?
> Thanks.|||It is not the date but the actual data. For example, the stored proc returns
a number that is 42984438 but when on the report I see 45711664. I have
deleted all .data files and I have changed the RSReportDesigner.config file
to have
<Add Key="CacheDataForPreview" Value="false" />. Still I am getting wrong
data from somewhere. I do no manipulation of the data in the report. All my
fields are just dragged and dropped into a table. Where is it getting the
data from?
"Wayne Snyder" wrote:
> GO to the properties of the field... It is probably set as a "general',
> change the property to date, and set the format... that should fix your
> problem
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Deb" <Deb@.discussions.microsoft.com> wrote in message
> news:BACEB8DD-D958-479D-A5B8-F2FDA24C085E@.microsoft.com...
> >I am running my report in the IDE. When I execute the stored proc from the
> > data tab, the result set has the correct data. When I Preview the report,
> > the data on the report is different from what is in the result set. I
> > have
> > made sure I used the same data in the report parameters that I used in the
> > query parameters. What causes this problem?
> >
> > Thanks.
>
>|||I am experiencing the same problem. I have posted a question titled "Columns
Not Consistent With Query". I am also using a SP with no manipulation of the
data. I found that the "incorrect" data in the column is always the same
value of the column in the row right above it.
If anyone responds to your question with a solution, would you please let me
know at danhaynes42@.hotmail.com and I will do the same for you. You could
send me your email to make this easier. Thanks. Dan Haynes.
"Deb" wrote:
> It is not the date but the actual data. For example, the stored proc returns
> a number that is 42984438 but when on the report I see 45711664. I have
> deleted all .data files and I have changed the RSReportDesigner.config file
> to have
> <Add Key="CacheDataForPreview" Value="false" />. Still I am getting wrong
> data from somewhere. I do no manipulation of the data in the report. All my
> fields are just dragged and dropped into a table. Where is it getting the
> data from?
> "Wayne Snyder" wrote:
> > GO to the properties of the field... It is probably set as a "general',
> > change the property to date, and set the format... that should fix your
> > problem
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Deb" <Deb@.discussions.microsoft.com> wrote in message
> > news:BACEB8DD-D958-479D-A5B8-F2FDA24C085E@.microsoft.com...
> > >I am running my report in the IDE. When I execute the stored proc from the
> > > data tab, the result set has the correct data. When I Preview the report,
> > > the data on the report is different from what is in the result set. I
> > > have
> > > made sure I used the same data in the report parameters that I used in the
> > > query parameters. What causes this problem?
> > >
> > > Thanks.
> >
> >
> >|||I am having the same problem with the pile of crap (Reporting
Services). Any one figured this gem out ?|||I am having the same problem with the pile of crap (Reporting
Services). Any one figured this gem out ?|||I have got to tell you that this is a little embarassing. My problem ended up
being that somehow the aggregate "first()" was in effect on the data in the
column that appeared to be wrong. This is why the result directly from the SP
was always correct and the result in the report was only wrong when a sort
order was selected that had a different value in the first row. From Deb's
description, this could also fit her description of the problem, but she is
probably more observant than I.
I will say that I have no idea how the aggregate "first()" got on the
column. There were 9 detail columns in the report and this is the only column
that had this done.
Dave, I understand your frustration because I was feeling it when it looked
like I had a really bizarre internal problem and no one was responding to my
postings. Not to sound like a cheerleader, but I have been extreemly
impressed with V1 of RS, even if it is a real bitch to get to run on a domain
controller.
I doubt this was any help, but I sincerely hope so.
"Dave" wrote:
> I am having the same problem with the pile of crap (Reporting
> Services). Any one figured this gem out ?
>