exception when loading a report from report server.
hai
i am new to ssrs reporting services
i create reports using visualstudio bussinessintelligence studio.and i deploy the reports in report server.
i want to consume the report from my c#.net windows application.
for this i consume the reportserver like webservice for this i add a webreference of
reportserver.
when i loading the report i got the following exception
i write code like this
ReportExecutionService rs =
new
ReportExecutionService();
rs.UseDefaultCredentials =
false;
rs.Url =
"http://2003Server/newReportServer/ReportExecution2005.asmx";
rs.Credentials =
new System.Net.NetworkCredential("HP01-HP",
"newdesire");
rs.Timeout = 500000;
ParameterValue[] reportParameters =
new
ParameterValue[1];
reportParameters[0] =
new
ParameterValue();
reportParameters[0].Name =
"Sales_quote_id";
reportParameters[0].Value =
"1";
ExecutionInfo execInfo =
new
ExecutionInfo();
rs.LoadReport(
"/Hollman/CabinetQuoteMaster",
null);
here i got the exception.
rs.SetExecutionParameters(reportParameters,
null);
An error occurred while printing ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Safertek.UFactory.Client.Core.ReportService.ReportExecutionService.LoadReport(String Report, String HistoryID)
why this exception comes.
what is the workaround for this.
if any one knows please help me.
thank you
March 18th, 2011 3:02pm