Last post Aug 26, 2011 03:12 PM by riddhiDev
Mar 07, 2011 04:10 AM|learnit|LINK
Iam using visual studio 2008 asp.net3.5 with c#.net
i want to call the sql server reporting services( ssrs) in asp.net .
how to acces that report in asp.net ie how to give this url
MyReportViewer.ServerReport.ReportServerUrl = new Uri("http://reportswebsite/Department");
i want to know what is the report server name, can you give example which helps me
Mar 07, 2011 07:16 AM|Nishantg|LINK
I hope this will help you.
Mar 14, 2011 08:53 AM|You-Hu Fu|LINK
From your information, I get that you want to display the report deployed on the report server via reportviewer
control in remote module, Visual Studio 2005 comes with freely redistributable Report Viewer controls for embedding Reporting Services functionality into custom applications.
Firstly, you should design your report in BIDS, then deploy the report on the report server, you might have already
done this from your information. What you should do is To add the Report Viewer control to the Web page:
Drag and drop the Report Viewer icon onto the WebForm design surface. The SmartTags panel for the control is automatically displayed.
ReportViewer Tasks smart tags panel, in Choose Report, select
Report Server text box, type the report server URL. The default URL syntax is http://localhost/reportserver. The actual URL that is used in your installation might be different depending on how the report server virtual directory settings
Report Path text box, type the fully qualified path of a published report. When referencing a report on a report server in native mode, the report path starts with a forward slash ( / ); For example: /Adventureworks 2008 Sample Reports/Company
Brouswer the report via IE, you will see the report deployed on the report server.
Configuring ReportViewer for Remote Processing
Using the ReportViewer Tasks Smart Tags Panel http://msdn.microsoft.com/en-us/library/ms252072(VS.80).aspx
Mar 15, 2011 03:40 AM|yehia software|LINK
after darag and drop report viewer control into asp page then you have two options
1-set the report to report viewer control in design time follow this steps :
a - select report viewer properties
b - select processing mode choose Remote
c - select server report and in ReportPath set the path of your report in the server note that the report path must start with (/) assuming that your report in folder in your server Reports then the report path is /Reports/yourReport.rdl
d- in your ReportServerUrl set The url of your server the default server if you don't now your sever url then open Reporting Service Configuration Manager choose Web Sevice Url you will find yor web server url at the bottom this is your report server
2 - using code
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportPath = "/Your Report path";
ReportViewer1.ServerReport.ReportServerUrl = "Your Server Url";
Aug 26, 2011 03:12 PM|riddhiDev|LINK
I am trying to work on SSRS with remote processing.
When i run my application on local machine ssrs report shows up fine.
but when i deployed application on application server, i am getting error mesage as below:
Microsoft.Reporting.WebForms.ReportViewerHandlerNotRegisteredException: The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file. Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler,
Microsoft.ReportViewer.WebForms, Version=184.108.40.206, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.web/httpHandlers section of the web.config file.
Please let me know how i can fix this issue. Thanks.