Install manually Watchdoc^® for Reporting Services

If you install the WRS^® reports set for a SQL 2012 or higher server, the install process is the following:

1. create a folder;

2. create a database;

3. deploy the reports.

Create the folder

1. Access the reports manager of Reporting Services (http://nomduserveur/Reports_WATCHDOC);

2. Click on New folder;
   
   
   
   

3. In the New Folder interface, enter the name of the file in which will be saved the WRS reports:
   
   
   

    

4. Click the OK button to validate the file adding;

5. Click the New Data Source button to access the configuration form:
   
   

6. in the form, fill the following fields:

• Name: enter in this field the database name;

• Connecting string: enter in this field:

• Data Source= enter the path to the database instance;

• Initial Catalog= enter the database name.

7. tick the radio button radio cochez le bouton radio corresponding to the choosen authentication mode;

8. click on the Test connection button to check the provided data validity;

9. click the OK button to add the data source.
   
   

Deploy the reports

1. In SQL Server Reporting Services, go to the Watchdoc^® file;

2. in the file menu, click the Upload file button;
   
   
   

3. Click on Browse and browse your workspace to select the first .rdl report (named Reports in the WRS sub-folder);

4. click on OK to validate the report choice:
   
   
   
   

5. Repeat this process for each .rdl file of the Reports folder;

6. Once finish, you can change the view by clicking on Detail Mode on right top to display the reports as lists.
   
   
   
   

7. Click on Statement to open the reports manager;

8. in the reports manager, specify the period for which you want to know the statistics, then click on Display the report.
   

   
   

    

→ The WRS reports setting is completed.