report does not show a table

Hi,

We have a report published to two report servers ( same configuration). this report displays data in two side by side tables. on server 1, the left side table does not get displayed where as both the tables show fine on server 2.

What could be the reason for this

Any help greatly appreciated.

Thanks,

Phani

I assume that the reports are pointing to different databases, so is there any data being returned for the table that doesn't show?|||

Hi,

It is the same report deployed on two webservers so they pull from the same database. One report shows both the tables with data and the second one shows only the right side table with data and does not show left hand side table.

Thanks,

Phani

|||

are the two tables using the same datasource?

could it be a time out issue from sql?

Have you looked into the reportserver log files and compared the results from each report server?

sql

Report Delivery Options To field is not editable

In the Report Delivery Options page of a new subscription the To: field is
read only. I followed the step: "Configuration Options for Setting the To:
Field in a Message" in the document "Configuring a Report Server for E-Mail
Delivery" http://technet.microsoft.com/en-us/library/ms159155.aspx. However
the To: field still can not be changed.
What am I over looking?
Thanks, MikeI donâ't know if it has to do with the way we are configured or a step that
was omitted for the procedure outline in my post below. But I logged off of
the network then back on and now the To: field can be change when subscribing.
"Mike Mullane" wrote:
> In the Report Delivery Options page of a new subscription the To: field is
> read only. I followed the step: "Configuration Options for Setting the To:
> Field in a Message" in the document "Configuring a Report Server for E-Mail
> Delivery" http://technet.microsoft.com/en-us/library/ms159155.aspx. However
> the To: field still can not be changed.
> What am I over looking?
> Thanks, Mike
>

Report and other controls not rendered

After resolving all the installation and configuration related issues, I was able to deploy a couple of projects on my report server. I can see alll folders and reports listed inside the folders from http://<servername>/reports . All works fine except when I run a report, the http://<servername>/Reports/Pages/Report.aspx page does not render report.

This page displays View, Properties, History Subscriptions etc, menu items on the top section of the page. It also displays Home, My Subscriptions, Site Settings, Help etc. links on top right corner of the page. I can also see the bar that has "New subscription" button. But the problem starts from the section below that. It does NOT display the Report navigation bottons (like First page button, Next Page button, previous page button, Last page button, print button etc.) Appears that the icons images for these bottons are missing. And above all, the page does not render report.

IE browser status indicate the following error:

error:'HoevrImagectl161_ctl01_ctl01_ctl06_ctl01' is null or not an object.

The report renders fine via http://<servername>/ReportServer/Pages/ReportViewer.aspx

I may not have explained the problem well here however, if you are interested, I can email you the screenshot of Report.aspx to help you understand the problem.

Any help is appreciated!!!

It seems you are using MOSS. Are you you have installed Sharepoint addon for Reporting Services found at http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

If you have. Have tou configured the reporting services in central admin - Application Settings?

If you have make sure in VS2005 you have deployed to the correct MOSS site collection and correct MOSS library and that is where you view your reports.

In MOSS the reports should render using RSViewerPage.aspx

Thanks
|||

Thanks for reply.

No. I am not running MOSS on this machine. Any other thought?

|||

I just uploaded the screenprint at :

http://i205.photobucket.com/albums/bb8/spnet/ReportSerrverProblem.jpg

P.s. : I have deliberately masked out the server name and parameter value.

|||

Pls help!! Any ideas?

|||

Woohhaaa!!!!!!!!! Figured that out.

It was a javascript error - "RSController.

Make sure your Reports website has the following seeting:

Right click "Reports" website on IIS manager

Go to Properties

Click on Virtual Directory tab

Click on Configuration button

In "wildcard Application Maps.." section, you should have the latest version of aspnet_isapi.dll file listed. If not listed, insert the file. Usually, the file is located at C:\Windows\Microsft.NET\Framework\<your version folder>\aspnet_isapi.dll

Now, click on "Edit" button. Make sure "Verify that File exixts" checkbox is UNCHECKED.

Click "ok" and exit out of Report properties dialogue box. Your reports should work now without IIS throwing any RSController or PramasCtl, imagehower etc. related errors.

Also visit:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327473&SiteID=1

thank you all!!

Report and other controls not rendered

After resolving all the installation and configuration related issues, I was able to deploy a couple of projects on my report server. I can see alll folders and reports listed inside the folders from http://<servername>/reports . All works fine except when I run a report, the http://<servername>/Reports/Pages/Report.aspx page does not render report.

This page displays View, Properties, History Subscriptions etc, menu items on the top section of the page. It also displays Home, My Subscriptions, Site Settings, Help etc. links on top right corner of the page. I can also see the bar that has "New subscription" button. But the problem starts from the section below that. It does NOT display the Report navigation bottons (like First page button, Next Page button, previous page button, Last page button, print button etc.) Appears that the icons images for these bottons are missing. And above all, the page does not render report.

IE browser status indicate the following error:

error:'HoevrImagectl161_ctl01_ctl01_ctl06_ctl01' is null or not an object.

The report renders fine via http://<servername>/ReportServer/Pages/ReportViewer.aspx

I may not have explained the problem well here however, if you are interested, I can email you the screenshot of Report.aspx to help you understand the problem.

Any help is appreciated!!!

It seems you are using MOSS. Are you you have installed Sharepoint addon for Reporting Services found at http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

If you have. Have tou configured the reporting services in central admin - Application Settings?

If you have make sure in VS2005 you have deployed to the correct MOSS site collection and correct MOSS library and that is where you view your reports.

In MOSS the reports should render using RSViewerPage.aspx

Thanks
|||

Thanks for reply.

No. I am not running MOSS on this machine. Any other thought?

|||

I just uploaded the screenprint at :

http://i205.photobucket.com/albums/bb8/spnet/ReportSerrverProblem.jpg

P.s. : I have deliberately masked out the server name and parameter value.

|||

Pls help!! Any ideas?

|||

Woohhaaa!!!!!!!!! Figured that out.

It was a javascript error - "RSController.

Make sure your Reports website has the following seeting:

Right click "Reports" website on IIS manager

Go to Properties

Click on Virtual Directory tab

Click on Configuration button

In "wildcard Application Maps.." section, you should have the latest version of aspnet_isapi.dll file listed. If not listed, insert the file. Usually, the file is located at C:\Windows\Microsft.NET\Framework\<your version folder>\aspnet_isapi.dll

Now, click on "Edit" button. Make sure "Verify that File exixts" checkbox is UNCHECKED.

Click "ok" and exit out of Report properties dialogue box. Your reports should work now without IIS throwing any RSController or PramasCtl, imagehower etc. related errors.

Also visit:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327473&SiteID=1

thank you all!!