locked
Accessing ssrs report in asp.net RRS feed

  • Question

  • User1467013749 posted

    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

    Monday, March 7, 2011 4:10 AM

Answers

  • User-830595639 posted

    I hope this will help you.

    http://www.codeproject.com/KB/webforms/ReportViewer.aspx

    http://www.codeproject.com/KB/books/Start_SSRS.aspx

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 7, 2011 7:16 AM
  • User1471008070 posted

    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. <o:p></o:p>

    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:

    1.     Drag and drop the Report Viewer icon onto the WebForm design surface. The SmartTags panel for the control is automatically displayed.

    2.     In the ReportViewer Tasks smart tags panel, in Choose Report, select Server Report.

    3.     In the 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 are configured.

    4.     In the 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 Sales 2008<o:p></o:p>

    Brouswer the report via IE, you will see the report deployed on the report server. <o:p></o:p>

    Reference:<o:p></o:p>

    Configuring ReportViewer for Remote Processing http://msdn.microsoft.com/en-us/library/ms252075.aspx <o:p></o:p>

    Using the ReportViewer Tasks Smart Tags Panel http://msdn.microsoft.com/en-us/library/ms252072(VS.80).aspx <o:p></o:p>

    Regards,<o:p></o:p>

    Challen Fu<o:p></o:p>

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 14, 2011 8:53 AM

All replies

  • User-830595639 posted

    I hope this will help you.

    http://www.codeproject.com/KB/webforms/ReportViewer.aspx

    http://www.codeproject.com/KB/books/Start_SSRS.aspx

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 7, 2011 7:16 AM
  • User1471008070 posted

    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. <o:p></o:p>

    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:

    1.     Drag and drop the Report Viewer icon onto the WebForm design surface. The SmartTags panel for the control is automatically displayed.

    2.     In the ReportViewer Tasks smart tags panel, in Choose Report, select Server Report.

    3.     In the 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 are configured.

    4.     In the 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 Sales 2008<o:p></o:p>

    Brouswer the report via IE, you will see the report deployed on the report server. <o:p></o:p>

    Reference:<o:p></o:p>

    Configuring ReportViewer for Remote Processing http://msdn.microsoft.com/en-us/library/ms252075.aspx <o:p></o:p>

    Using the ReportViewer Tasks Smart Tags Panel http://msdn.microsoft.com/en-us/library/ms252072(VS.80).aspx <o:p></o:p>

    Regards,<o:p></o:p>

    Challen Fu<o:p></o:p>

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 14, 2011 8:53 AM
  • User351081279 posted

    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 url 

    2 - using code

       ReportViewer1.Reset();
                ReportViewer1.ProcessingMode = ProcessingMode.Remote;
                ReportViewer1.ServerReport.ReportPath = "/Your Report path";
                ReportViewer1.ServerReport.ReportServerUrl = "Your Server Url";

     

    Tuesday, March 15, 2011 3:40 AM
  • User-1571401293 posted

    hi,

    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=9.0.0.0, 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.

    Friday, August 26, 2011 3:12 PM