Q: this strange problem

I am having this strange problem, when I run my query in Query Analyzer, I
see the result is ok. But my report based on the same query shows first filed
repeats itself instead of showing right values. What might the problem be?Is this in development? In development the report data is cached (look for a
file with an extension called .data). If you change the paramter it will
requery. If no parameter then you can manually delete this file if you care.
The designer does this so when previewing you are not waiting for the query
to run.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:9E917150-64CD-43FA-8E80-84E716FC6AFE@.microsoft.com...
>I am having this strange problem, when I run my query in Query Analyzer, I
> see the result is ok. But my report based on the same query shows first
> filed
> repeats itself instead of showing right values. What might the problem be?