Navigation Menu

Click the "+" to see inside a chapter or use the search to the right.

.

Skip to end of metadata
Go to start of metadata

 Upgrade application files

 Run all scripts for database migration

 Software upgrade process home page

Icon

The following is applicable only for ExamDeveloper version 7.1702.0.0 or less.

 

The SSRS .RDL files can be updated in 2 ways. You may opt to upload and configure the .RDL files either automatically using a utility ReportDeploy.exe from the ReportUpgradeUtility.7z file of the <SVNFolder>\External folder or manually.

Automatically upload the .RDL files using ReportDeploy.exe 

Icon

It is important to ensure that all the values in the config files such as service name, URLs, username, and password are case-sensitive. ExamDeveloper may not run as expected if care is not taken to ensure that case sensitivity is maintained.

Locate the ReportUpgradeUtility.7z in the <SVNFolder>\External folder and extract it to a folder. Open the ReportDeploy.exe.config file located inside this extracted folder and open it with Notepad or a suitable text file editor.

  1. Modify the value in the <connectionStrings> section as follows:
    1. Data Source = Name of SQL Server instance.
    2. Initial Catalog = ExamDeveloper (which is the ExamDeveloper database) (ExamDeveloper_New in case of side-by-side (additional instance) installation).
    3. User ID = Username of the SQL Server User who owns the database. This was created during SQL Server Database Setup under SQL Server user management. In our example, this is "ExamDev".
    4. Password = Password of the SQL Server who owns the database. This was created during SQL Server Database Setup under SQL Server user management. In our example, this is "P@s$w0rd".

    In our example, this is as below:
  2. Modify the values in the <appSettings> section as follows:
    1. rdlFilesPath = Path of the RDL files inside the SVN checkout folder structure - <SVNFolder>\Reports (in our example, C:\ExamDeveloper\Repositories\ExamDeveloper\Reports).
    2. reportServerUrl = Report Server Web Service URL shown on the Web Service URL tab of the Reporting Services Configuration Manager.

      Icon
       Where is the Report Server URL? Click to learn...

      The Report Server Web Service URL can be found by clicking the Web Service URL link on the left as shown below. If the URL is too long, some part of the URL may not be visible. In such a case, you can hover the mouse cursor over the URL and note it down from the tool-tip.



    3. reportServerUserName = The administrative username (user with Browser and Content Manager roles) used to log into the Report Manager, in step 8 of Setting up Reporting Services application folder.
    4. reportServerPassword = The password for the administrative username used to log into the Report Manager, in .
    5. reportServerDomainName = The domain name where the reporting service is hosted. You can find this from Control Panel > User Accounts.
    6. reportDataSourceName = This is the DSN name "ExamDeveloper_DSN" as mentioned in step 3 of Creating DSN (Data Source Name) for Report Server.
    7. reportFolderName = The folder name and path of the reporting services application folder created in step 7 of Setting up Reporting Services application folder, which is /ExamDeveloper/ in our example.  Do not modify this value unless for side-by-side (additional instance) installation, where this is different such as "ExamDeveloper_New" in our example). This should match the value of "reportServerPath" in the application's appSettings.config file as in step 6 of the Configure ExamDeveloper page.

    In our example, this will be as below:
  3. Modify the value in the <applicationSettings> section as follows:
    ReportDeploy_ReportService2005_ReportingService2005 = This should be modified to "reportServerUrl/ReportService2005.asmx", where the value for "reportServerURL" is the same as the one used in point 2.b above.
  4. Save the ReportDeploy.exe.config file.
  5. Double-click the ReportDeploy application in the same extracted folder.
  6. Report Upload process is completed’ message is displayed on the successful execution of the application.

Manually upload and configure .RDL files

 To read about how to upload the reports manually, click here to expand...

Follow the steps mentioned below to manually upload and configure .RDL files.

  1. In the SQL Server Reporting Services Home page, under ExamDeveloper (ExamDeveloper_New in case of side-by-side (additional instance) installation), in the top menu, click the Upload File button. This opens the Upload File page.
  2. Click the Browse button, to browse to the .RDL file to upload to the report server. Reports are stored in the Reports directory inside the <SVNFolder> folder extracted earlier. See ExamDeveloper Application Files.
     
  3. In case there is no name in the Name column, enter the name of the report there and click OK.
  4. This takes you back to the SQL Server Reporting Services Home page. Here, the uploaded report name is displayed. Click the menu button displayed on the right side of the report name and select Manage from the list.

  5. This displays the Properties page for the selected report. In the left side menu, click the Data Sources link.
     
  6. You should see the correct data source (/ExamDeveloper/ExamDeveloper_DSN in our example) under the A shared data source radio button selection as shown below. (Note: For side-by-side (additional instance) installation, you should see the correct data source as /ExamDeveloper_New/ExamDeveloper_DSN). If the correct data source is not displayed, go to the next step. If the correct data source is displayed, skip to step 10.
     
  7. If the correct data source is not displayed, you must manually specify it. Click the Browse button to browse to select the correct data source.
  8. This takes you to a browse page as shown below, where you must select the DSN created earlier in Creating DSN for Report Server (ExamDeveloper_DSN in our example). Click OK.

  9. This brings you back to the report Data Sources page and the correct data source is displayed. Click the Apply button.
  10. Now, in the top menu, click the ExamDeveloper link (ExamDeveloper_New link in case of side-by-side (additional instance) installation), and repeat the above steps for other .RDL files to be uploaded.
      

  11. Close Internet Explorer once you are done following the above steps with all the .RDL files.

 

 

Good Practice: Always update all SSRS Reports

Icon

Unless you know exactly which reports were updated in the last release, it is good practice to update all SSRS .RDL files. This way you can ensure that all of the reports which changed from the previous release are updated. 



Return to the top of the page

 Run all scripts for database migration

 Upgrade application files

 Software upgrade process home page

 

  • No labels