Monday, March 19, 2012

Cannot View Reports in Report Manager

Alrighty... This has been a bugger of a pain all day.
We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed the default website and relocated the virtual directories to a different website, which is accesible over the network via an ip address. I can get into the report manager just fine.
Here's the problem: when I click on a report in the report manager, I cannot view the report. Initially the problem was that it would give a 403 access forbidden message, which doesn't make sense since the user was a content manager and full rights were available across the board. Now after several hours of playing it gives an action cancelled, cannot link to the requested webpage error. It gives it on any report, but I can access the report properties just fine. I can get into data sources just fine as well.
Upon reading something in here, I've tried editing the RSWebApplication.config file to change the
<ReportServerUrl>http://TestWWW/ReportServer</ReportServerUrl>
value to
<ReportServerUrl>http://10.1.1.74/ReportServer</ReportServerUrl>
which is the address of the site it should be located at. When I do that and save it, it get's kinda interesting - when I try to view any report, I get a directory listing (with it enabled for the directory) of 10.1.1.74 - /ReportServer/. Then when I click any of the directories, it takes me to 10.1.1.74/ReportServer/ - (note the change in hyphens) which displays all the uploaded files on the report server. If I click on a report, it displays the report!
What the heck is going on? Anyone seen this and fixed it?
- TCorrection: when I said it displayed the report, I spoke too soon. It brings up the window with the standard report bars, but hangs with the green spinning generation graphic.

No comments:

Post a Comment