SSRS Report from View

0
votes

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?

1
reporting-servicesssrs-2008sql-server-2000reportingservices-2005ssrs-2008-r2
A couple of questions - Are you viewing the report on BIDS or on the browser through report viewer? Does it happen for all reports or specifically for this report? – Andy Dufresne
Which SSRS version are you using? you have 3 tagged in your post. – Jt2ouan

1 Answers

1
votes

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.