CODEWITHSUNDEEP
reporting-servicesssrs-2008sql-server-2000reportingservices-2005ssrs-2008-r2
user1254579
user1254579

Reputation: 4009

SSRS Report from View

An SSRS report has been created .The dataset has been defined on bases of a query.The query is

SELECT Organisation,
       SUBSTRING(CONVERT(VARCHAR, dt_dt), 1, 11) AS Expr1,
       CNT
FROM   v_111_status

Every time I refresh the data in the view and run the ssrs report ,I can not see those changes reflected on the SSRS reports!

When i fire the above query in SSMS , I can see the changes!

Is any of the dataset property has to be checked to get the data?

Upvotes: 0

Views: 216

Answers (1)

Jt2ouan
Jt2ouan

Reputation: 1964

Did you try opening the dataset properties in SSRS and clicking "Refresh Fields". If you made changes which created new fields etc... you won't see them until you click "Refresh Fields".

enter image description here

If the problem isn't that you adding new columns etc... you should try refreshing the report. In the preview tab click the refresh button and see if that helps:

enter image description here

If you're still seeing an issue try to delete any files in the report project solution folder that have an extension of .rdl.data, this file holds details that caches/save the data of the last time you ran the report locally. It is not an important file and will do no harm when you delete it.

Upvotes: 1

Related Questions