Answered by:
Develop custom Report Viewer Web Part by inheriting Out of Box Report Viewer Web Part

Question
-
I am using reporting services in SharePoint integrated mode; and showing report on SharePoint 2007 site using Out of Box Report Viewer web part.
I have some requirements which are not fulfilled by Out of Box report viewer web part, so I need to develop my own custom web part, which will provide all features of Out of Box Report Viewer web part and I can add my own custom features which will satisfy my requirements.
Features I am expecting in custom web part:
1) All existing features of Out of Box Report Viewer web part.
2) Personalize default parameter loading in parameter pane (user specific default parameter).
3) Customize the parameter selection pane, which report viewer web part provides.
4) Popup message Box on invalid parameter selection.
5) Need to use relative path of report URL in web part configuration, take advantage of AJAX, etc…
I would appreciate your thoughts about developing custom report viewer web part or similar solution.
Thanks in Advance,
AmitMonday, February 1, 2010 11:55 PM
Answers
-
Well I suppose you still want the features that are not available in the standard one, right? :) So you will still need to customize the Web part.
I haven't inherited anything from the Report Viewer Web part, but even Chengyi provided links to report viewer control, which I suppose is the better approach in this case, because I reckon there is more than just a Web part in standard that you have to bear in mind.
Anyway it would be interesting to know how do you go with your idea.
Best wishes,
Slava G
http://wyldesolutions.com
http://wyldesharepoint.blogspot.com- Marked as answer by Chengyi Wu Friday, February 12, 2010 2:15 AM
Thursday, February 4, 2010 7:47 AM
All replies
-
Hi Amit,
I think you can start with using a report viewer control on yur Web part?
I haven't used it myself, but I suppose that's what could be useful.
Best wishes,
Slava G
http://wyldesolutions.com
http://wyldesharepoint.blogspot.comTuesday, February 2, 2010 4:01 AM -
Thanks Slava G.
I am also thinking about to use ASP.Net report viewer control in custom web part, but in this case we can’t take advantage of features which are available in Report Viewer web part, we need to build web part from scratch.
Please share thoughts on this.
AmitWednesday, February 3, 2010 6:47 PM -
1. You need to activate the SharePoint Reporting Integration feature.
Please reference:
How to: Configure Report Server Integration in SharePoint Central Administration(http://technet.microsoft.com/en-us/library/bb326213.aspx)
Report Server in SharePoint Integrated Mode How-to Topics(http://msdn.microsoft.com/en-us/library/bb283321.aspx)
Configuring Reporting Services for SharePoint 3.0 Integration(http://msdn.microsoft.com/en-us/library/bb326356.aspx)
2. You need to make sure that the user who runs the services is joined to the IIS_WPG and the WSS_WPG groups on the server.
3. You can read the following article to use the ReportViewer Control in Remote Mode (http://msdn.microsoft.com/en-us/library/ms251669%28VS.80%29.aspx)
4. You can reference the following article on the comprehensive understanding of ReportViewer Control development:
ReportViewer Controls (Visual Studio) (http://msdn.microsoft.com/en-us/library/ms251671%28VS.80%29.aspx)
Cogito, ergo sum.Thursday, February 4, 2010 2:08 AM -
Well I suppose you still want the features that are not available in the standard one, right? :) So you will still need to customize the Web part.
I haven't inherited anything from the Report Viewer Web part, but even Chengyi provided links to report viewer control, which I suppose is the better approach in this case, because I reckon there is more than just a Web part in standard that you have to bear in mind.
Anyway it would be interesting to know how do you go with your idea.
Best wishes,
Slava G
http://wyldesolutions.com
http://wyldesharepoint.blogspot.com- Marked as answer by Chengyi Wu Friday, February 12, 2010 2:15 AM
Thursday, February 4, 2010 7:47 AM