Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.sql

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.

report viewer web part error

I'm having problems with the SharePoint configuration on a REport Viewer web
part. When Report Explorer and Report Viewer are used together, all is fine.
This is just trying to configure Report Viewer as a stand alone web part.
My direct URL path to a report is:
http://server01/Reports/Pages/Report.aspx?ItemPath=%2fCorporate+Applications%2fOpen+Requests+By+Priority
In the Report Manager URL box, I have http://server01/Reports.
In the Report Path box I have:
/Pages/Report.aspx?ItemPath=%2fCorporate+Applications%2fOpen+Requests+By+Priority.
I get the Reporting Services Error in the Report Viewer web part:
"The path of the item
'/reportserver?%2fCorporate+Applications%2fOpen+Requests+By+Priority&rs:Command=Render'
is not valid. The full path must be less than 260 characters long, must start
with slash; other restrictions apply. Check the documentation for complete
set of restrictions. (rsInvalidItemPath) "
Of course the doc just tells me my path is too long, which it's not.
Any ideas?
Thanks,
PaulI have the same problem...did you figure out a solution? If so, can
you send it to me at ram.pisipati@.lmco.com
Thanks
Ram|||Hi,
I got the same error !
solution:
just enter the folder name from reporting service
i.e. /AD+Site+Reports
Torsten
ram.pisipati@.lmco.com schrieb:
> I have the same problem...did you figure out a solution? If so, can
> you send it to me at ram.pisipati@.lmco.com
> Thanks
> Ram|||Not sure I understand you correctly. Where do you want me to enter the
folder name?
the report viewer web part takes two parameters and this is what I am
entering for each of the parameters
Report Server path: http://www.myserver.com/Reports/?
Report path: /TestFolder/TestReport
Thanks in advance
Ram

Report Title in Internet Explorer Tab

Is there a way to show the report title in an Internet Explorer tab instead
of having it render "Report Viewer"? Seems that users are opening many
reports and it is hard to find the one you want with many windows open. Any
Thoughts?
Thanks
RickOn Nov 2, 1:41 pm, Rick Spicknall
<RickSpickn...@.discussions.microsoft.com> wrote:
> Is there a way to show the report title in an Internet Explorer tab instead
> of having it render "Report Viewer"? Seems that users are opening many
> reports and it is hard to find the one you want with many windows open. Any
> Thoughts?
> Thanks
> Rick
As far as I know, there is not. The closest thing you will be able to
do is export the report(s) to Web Archive (MHTML) and the report name
itself will appear in the IE tab. Of course, if you are willing to
render the reports to web archive programmatically, you can build an
ASP.NET application that allows you to append HTML to the web archive
output (via possibly: Streamreader, Stringbuilder.Append and
Streamwriter) and try to create the IE tabs from the Report Title
information. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant