Reader Level:
ARTICLE

How to Configure Reports on Server

Posted by Sanjeev rajput Articles | SQL February 08, 2013
How to configure reports on server and with ASP.NET.
  • 0
  • 0
  • 2188

How to configure reports on server

  • Open reports project in Visual Studio.
  • Click on "View" => "Solution Explorer".
  • When we double-click on Datasource.rds then a window will be opened as follows.

    Image 1.jpg
     
  • Change the connection string according Server details.
  • Right-click on the report project in Solution Explorer as follows:

    Image 2.jpg
     
  • Click on the property; a window will be opened as follows:

    Image 3.jpg
     
  • Change TargetServerURL according server details.
  • Now again right-click on the report project in Solution Explorer as follows:

    Image 4.jpg
     
  • Click on deploy and the report(s) will be deployed on the server successfully.
     
  • For testing please type the Reports server URL into the browser.
  • For example: "http://192.168.1.12/Reports"; a window will be opened as follows:

    Image 5.jpg
     
  • Here we can test the report (s) by clicking on the report folder.

How to configure reports with ASP.NET

  • Change the server details in the Web.config file correspondingly, as follows:

    <appSettings>

        <addkey ="ReportServerURL"value ="http://192.168.1.12/ReportServer"/>

        <addkey ="UID"value ="serveradmin"/>

        <addkey ="PWD"value ="admin123"/>

        <addkey ="Domain"value ="dibonchd"/>

        <addkey ="ReportPathORG"value="/MailingReportORGSize/LebelORG"/>

        <addkey ="ReportPathPerson"value ="/MailingGHRajSize/GHRajLabel"/>

        <addkey ="ReportPathFunction"value ="/GHRajReports/FunctionAcceptLetter"/>

        <addkey ="ReportPathRejFunction"value ="/GHRajReports/FunctionRejectLetter"/>

       
      </appSettings> 

COMMENT USING

Trending up