处理本地报告给出错误 [英] Processing local report is giving error
问题描述
大家好,
我有一个小型的网络应用程序,我提供的报告很少。它们都完全适用于开发机器,但是当我将软件移动到客户端机器时,我收到错误。
本地报告期间发生错误处理。
报告处理过程中出错。
用户'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屋!