x

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.
more ▼

asked Dec 13, 2011 at 10:10 AM in Default

Doug gravatar image

Doug
43 4 4 4

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
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.
more ▼

answered Dec 13, 2011 at 11:42 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

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.
Dec 13, 2011 at 02:07 PM Doug
(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Dec 13, 2011 at 02:09 PM

Doug gravatar image

Doug
43 4 4 4

(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Dec 13, 2011 at 03:43 PM

Doug gravatar image

Doug
43 4 4 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x29

asked: Dec 13, 2011 at 10:10 AM

Seen: 1897 times

Last Updated: Dec 13, 2011 at 10:10 AM