处理本地报告给出错误 [英] Processing local report is giving error

查看:89
本文介绍了处理本地报告给出错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好,



我有一个小型的网络应用程序,我提供的报告很少。它们都完全适用于开发机器,但是当我将软件移动到客户端机器时,我收到错误。



本地报告期间发生错误处理。

报告处理过程中出错。

用户'domain \机械名称$'登录失败。




以下是Web.config文件中的设置



Hello everybody,

I have a small web application in which I am providing few reports. They all work perfectly on development machine, however when I move the software to client machine I get an error.

An error occurred during local report processing.
An error has occurred during report processing.
Login failed for user 'domain\machine name$'.


Following is the setting from Web.config file

<?xml version="1.0" encoding="UTF-8"?>

<configuration>
    <connectionStrings>
        <remove name="LocalSqlServer" />
        <add connectionString="Data Source=ql1;Initial Catalog=curo_support;Integrated Security=True; MultipleActiveResultSets=True" name="curo_supportConnectionString" providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.web>
 <compilation debug="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
      </assemblies>
      <buildProviders>
        <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
      </buildProviders>
        </compilation>
        <authentication mode="Windows" />
 <identity impersonate="true" password="xxxxxxxx" userName="<domain name>\<username>" />
          <authorization>
            <deny users="?" />
          </authorization>
    </system.web>
    <system.webServer>
        <handlers>
          <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
        </handlers>
    </system.webServer>
</configuration>







最后以下是显示报告的代码






And lastly following is the code to display report

<form class="form-horizontal" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" InteractiveDeviceInfos="(Collection)"

            WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="100%" Height="100%" SizeToReportContent="true"           AsyncRendering="False" ShowPrintButton="false">
            <LocalReport ReportPath="report\empty_key_list.rdlc">
                <DataSources>
                    <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
                </DataSources>
            </LocalReport>
        </rsweb:ReportViewer>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"

            ConnectionString="<%$ ConnectionStrings:curo_supportConnectionString %>"

            SelectCommand="kms_rpt_empty_key_list"

            SelectCommandType="StoredProcedure">
        </asp:SqlDataSource>
    </div>
</form>





有人可以告诉我我错过了什么或我错在哪里吗?



非常感谢提前



Can somebody please tell me what I am missing or where am I going wrong?

Many thanks in advance

推荐答案

'。



以下是Web.config文件中的设置



'.

Following is the setting from Web.config file

<?xml version="1.0" encoding="UTF-8"?>

<configuration>
    <connectionStrings>
        <remove name="LocalSqlServer" />
        <add connectionString="Data Source=ql1;Initial Catalog=curo_support;Integrated Security=True; MultipleActiveResultSets=True" name="curo_supportConnectionString" providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.web>
 <compilation debug="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
      </assemblies>
      <buildProviders>
        <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
      </buildProviders>
        </compilation>
        <authentication mode="Windows" />
 <identity impersonate="true" password="xxxxxxxx" userName="<domain name>\<username>" />
          <authorization>
            <deny users="?" />
          </authorization>
    </system.web>
    <system.webServer>
        <handlers>
          <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
        </handlers>
    </system.webServer>
</configuration>







And lastly following is the code to display report






And lastly following is the code to display report

<form class="form-horizontal" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" InteractiveDeviceInfos="(Collection)"

            WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="100%" Height="100%" SizeToReportContent="true"           AsyncRendering="False" ShowPrintButton="false">
            <LocalReport ReportPath="report\empty_key_list.rdlc">
                <DataSources>
                    <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="DataSet1" />
                </DataSources>
            </LocalReport>
        </rsweb:ReportViewer>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"

            ConnectionString="<%


ConnectionStrings:curo_supportConnectionString %>\"

SelectCommand=\"kms_rpt_empty_key_list\"

SelectCommandType=\"StoredProcedure\">
</asp:SqlDataSource>
</div>
</form>
ConnectionStrings:curo_supportConnectionString %>" SelectCommand="kms_rpt_empty_key_list" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> </div> </form>





Can somebody please tell me what I am missing or where am I going wrong?



Many thanks in advance



Can somebody please tell me what I am missing or where am I going wrong?

Many thanks in advance


Just search the error message in Google, you’ll find many answers. Here few

Reporting viewer won’t show report[^]

An error occurred during client rendering.An error has occurred during report processing.Cannot create a connection to data source ’AW’.Login failed for user ’’[^]

An error has occurred during report processing. Login failed for user ’(null)’[^]
Just search the error message in Google, you'll find many answers. Here few
Reporting viewer won't show report[^]
An error occurred during client rendering.An error has occurred during report processing.Cannot create a connection to data source 'AW'.Login failed for user ''[^]
An error has occurred during report processing. Login failed for user '(null)'[^]


这篇关于处理本地报告给出错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆