asked
Detail report is blank after deploying
Hello all, I have an SSRS report that runs good in Visual Studio but after it's deployed to our intranet, the detail portion of the report is blank and only showing the headers. However, the summary detail portion does display. Ther are other reports that work fine on the intranet and only this one does not work. I've try to re-deploy the report but it keep producing the same result. Any help will be greatly appreciated. I'm running Visual Studio and the intranet with the same user login account. This is in SQL 2005.
Is your report referencing correct DataSource after deployment to a production? Check the properties, fo the report that the data source is set correctly. It can happen that it points to Deve nvironmnet whereas the main report points to correct production data source.
Yes, I've checked the data source and it's referencing to Production. The report runs several stored procedures, I've also checked the permissions for the stored procedures and they looked correct. Any other suggestions? It just seems odd that a portion of the report runs and not the whole in the intranet.
After further review of the queries and stored procedures, it turns out that a select statement was enbeded into one of the stored procedures for debugging purpose and was not removed and the Visual Studio project was not refreshed after the select statement was added, hence Visual Studio worked but once the report was deployed, the report did not. Thank you for your review.
