Hi, I am developing a report in SSRS 2008 R2. My dataset is expected to get records from a stored procedure. The stored procedure works fine in my development area and I could see the output rendered properly in my RDL report. However, when the same report is deployed on the server, there's no records fetched. I did a trace on call of that report... the stored procedure is being called, it does what it is expected to do... but then for some reason SSRS doesn't get any records to be displayed on the report. I even executed the stored procedure manually on the server's SSMS, which gave the output. What could be the issue here? Thanks, {P} Microsoft Techie

Hi, Check the report DataSource ConnectionString. It seems that on report manager, Your report is pointing some other datasource. Aftab Ansari

Aftab, I already checked it. I have a shared data source and its pointing to correct database.Microsoft Techie

:bump:Microsoft Techie

Hi, Can you check the Execution behavior of your report? Check whether your report is running for the most recent data or any snapshot. Aftab Ansari

Its the same.... 'Always run this report with the most recent data', which is the default.Microsoft Techie

I finally landed up deleting my shared data source and then recreate it on the server's report manager. The report works fine now. However, all the other reports that were dependent on that shared data source needs to be reconfigured as their data source value got erased when I deleted the shared data source. So the above solution is definitely not recommended if you have many reports already published on the server. Cheers! Microsoft Techie