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

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

[quoted text, click to view]