sql server reporting services: Data on report different than what is in result set from stored pr -- sql server reporting services

Re: Data on report different than what is in result set from store

Deb
2/7/2005 6:15:02 AM

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?

[quoted text, click to view]

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

Wayne Snyder
2/7/2005 8:14:20 AM

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

[quoted text, click to view]

Re: Data on report different than what is in result set from store

Dan Haynes
2/8/2005 4:03:05 AM

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.

[quoted text, click to view]

Re: Data on report different than what is in result set from store

Dave
2/25/2005 4:39:29 PM

I am having the same problem with the pile of crap (Reporting
Services). Any one figured this gem out ?

Re: Data on report different than what is in result set from store

Dave
2/25/2005 4:39:50 PM

I am having the same problem with the pile of crap (Reporting
Services). Any one figured this gem out ?

Re: Data on report different than what is in result set from store

Dan Haynes
2/25/2005 6:07:02 PM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.