MOSS2007自定义aspx页面中使用ReportViewer控件

在assemblies新增

      <buildProviders>
        <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
      </buildProviders>

修改或新增httpHandlers

<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

新增 safecontrol

<SafeControl Assembly="Microsoft.ReportViewer.WebForms,Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TypeName="*" Safe="True" />

遇见错误：

The type 'Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' does not implement IReportViewerMessages

在webconfig 中 appsettings 下加入：

<remove key="ReportViewerMessages" />

 

参考：

http://blogs.msdn.com/b/solutions/archive/2007/10/29/installing-sql-reporting-services-and-moss-2007-on-the-same-port-default-80.aspx

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/228a697f-f391-4b04-8d30-aaca0e91130b/

 

遇见错误：

In remote mode, the Report Viewer control requires session state be enabled or Report Server connection information specified in the config file.

fix：

In your app's web.config make sure that the <pages> tag has the following properties:

<pages enableSessionState="true" enableViewState="true">

and in your <httpModules> section make sure you have the following entry:

<add name="Session"  type="System.Web.SessionState.SessionStateModule"/>

and after the <httpModules> section, include: <sessionState mode="InProc" cookieless="false" timeout="20"/>

 

或者

 

Try using the following

<appSettings>

<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

<add key="ReportServerUrl" value="your report server url" />

</appSettings>

 

 

参考：

http://social.microsoft.com/Forums/en-US/crmdevelopment/thread/024abdfb-967e-478b-acfe-739f7b7e693a/

http://forums.asp.net/t/1308086.aspx/1

 

遇到错误

That assembly does not allow partially trusted callers

Fix:

修改Web.config

<trust level="Full" originUrl="" />

参考：

http://social.msdn.microsoft.com/Forums/zh-SG/sharepointdevelopment/thread/1e47c5c8-4608-4da0-81d2-ce3d82272420

 

遇到错误

• The request failed with HTTP status 401: Unauthorized.

Fix:

新建类

    [Serializable]
    public partial class ReportViewerCredentials : IReportServerCredentials
    {
        private string _userName;
        private string _password;
        private string _domain;

        public ReportViewerCredentials(string userName, string password, string domain)
        {
            _userName = userName;
            _password = password;
            _domain = domain;

        }

        public ReportViewerCredentials()
        {
            //_userName = userName;
            //_password = password;
            //_domain = domain;

        }


        public WindowsIdentity ImpersonationUser
        {
            get
            {
                //return null;
                return WindowsIdentity.GetCurrent();
            }
        }

        public ICredentials NetworkCredentials
        {
            get
            {

                return new NetworkCredential(_userName, _password, _domain);
                //return System.Net.CredentialCache.DefaultCredentials;
            }
        }

        public bool GetFormsCredentials(out Cookie authCookie,
                out string userName, out string password,
                out string authority)
        {
            authCookie = null;
            userName = _userName;
            password = _password;
            authority = _domain;

            // Not using form credentials   
            return false;
        }

    }      

 

设定 reportviewer 的credentials

this.ReportViewer1.ServerReport.ReportServerCredentials = new ReportViewerCredentials("name", "password", "domain");