Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Report in report viewer comes up as blank

Author  Topic 

sqlbug
Posting Yak Master

201 Posts

Posted - 2012-05-10 : 13:45:19
Hi,
I have two reports to deploy to client. Before we do that, we test them in 2 websites in our server. First website is a generic one - other site is specifically for the client's pages testing before final deployment in client location.

We built the first report - it runs fine in the generic site, but comes up with the blank report viewer in the clients test site. No errors. Both sites using same settings and connection strings.
In the same site - other reports run exactly the same way (report viewer control hosted in a .net page) - therefore its not like a common thing happening to all sql reports (I tried google searches and they all came up with situations where all reports behave same way because of IIS settings etc.)

FYI - Im using VS 2008 for the reports (that uses the RDL format 2005).

Any ideas ? It's really an urgent situation.
Thanks,

sqlbug
Posting Yak Master

201 Posts

Posted - 2012-05-10 : 17:32:03
Updates - I've found a very weird thing happening.

The whole report is in a table and the whole table is not coming up, that's why it was blank.
I've tried a small table on a test report. Static text on the report header row shows up. No static or dynamic content in the details row displays.
The table's width is squeezed down to half inch where as the size is 6.5 inch.

Please don't think that this has anything to do with the Hidden or any other property not properly set. All the properties are perfectly set and I checked it - including in xml editor.

More interesting the exact same report runs/shows perfectly in VS 2010 (RDL 2008 format). Therefore - we are going to switch onto the new version instead of staying bogged down by the older weird version.
Go to Top of Page
   

- Advertisement -