Installing SSRS Reports

Application Setup

Please ensure the latest HR Application is installed on the same system as the HR Web Service as this implementation will control the provision of information by the Web Service.

QLX

For the webparts to work correctly with QLx, it is required to setup a non-administrative user called REMOTE_HR.

THE SOFTWARE

A Software Portal user must be set in the Connection Manager (jsconnection.exe).

Install the HR SOAP Web Service

Note: if you have already installed the HRWebService, skip to step 3 and install the SOAP Web Service to the same site as the HRWebService.

1. You will need to create a new application pool (called HRSOAPWebService) within Internet Information Services (IIS) Manager, ensuring that you are running as the administrator (right click IIS Manager -> Run as Administrator). Verify that the .Net Framework Version of the application pool is set to v2.0.50727. If not, change it under Basic Settings. Once the application pool has been created, go to Advanced Settings, and set Enable 32-Bit Applications to true.

2. Next you will need to create a new web site (same name as application pool for consistency) where the HR SOAP Web Service will be hosted. Make sure that the application pool is set to the application pool created in step 1. Create a new folder, C:inetpubHRSOAPWebService and set that as the physical path. The port number can be any number as long as it doesn’t conflict with any existing web sites (recommended to be 8000 or greater).

3. Download and unzip HRSOAPWebService.zip, select setup.exe and follow the instructions of the installation wizard, installing the web service to the web site created above. Note: if the HRWebService has already been installed, then select that website to install the web service to.

4. If you get an error indicating that the installer was interrupted before HR Web Service could be installed, verify that the following Role Service has been enabled:

Go to the service roles of the computer:

Control Panel > Programs > Programs and Features > Turn Windows features on or off

Find the IIS Service Role and add a new role service:

Roles > Web Server (IIS) > Add Role Service

Make sure the following option is ticked on:

Management Tools > IIS 6 Management Compatibility > IIS 6 Metabase Compatibility

Re-run the HR SOAP Web Service installer.

5. Edit the Web.Config as an administrator in the HRSOAPWebService and make sure that the Jane.Environment key is to “QL” for QL-x, or “JANE” for Jane HR.

6. To verify that the web service is functioning correctly, within a web browser, navigate to the web site where you installed the HR Web Service (https://<HRSOAPWEBSERVICE_SITE>/HRSOAPWebService/CallComObject.asmx).

Note: <HRSOAPWEBSERVICE_SITE> should be replaced with the appropriate URL (the website where the HR SOAP Web Service was installed).

Note: If you receive an access error in step 6, check the web site’s authentication. In the IIS Manager, click on the web site where the HR Web Service is installed and click on Authentication. You’ll need to ensure that Annonymous and/or Windows Authentication is enabled (more information: https://technet.microsoft.com/en-us/library/cc733010(v=WS.10).aspx).

Deployment

  • Download the Deploy Reports and Jane Payroll Reports zip files
  • Extract both zip files and put them together in one folder (typically, the Jane Payroll Reports folder)
  • Identify what mode SSRS is running (Native/SharePoint), and follow the correct notes corresponding to the mode that is running below:

Native Mode:

If you are running Reporting Services in Native Mode, edit the Deploy Reports.cmd and modify the variables shown below:

Variable Description
sourceReportsFolder The folder containing the reports to deploy
ssrsURL The URL of the SQL Server Reporting Service Web Service
reportFolder The SSRS folder that the reports will be deployed to
dataSourceFolder The SSRS folder that will contain the data connection file
dataSourceUrl The URL of the HR SOAP Web Service

Once the parameters have been modified, run the Deploy Reports.cmd batch file as an administrator (it is recommended to run this from a Command Prompt so that you can see any (potential) errors).

The script must be run on the server running Reporting Services.

SharePoint Integrated Mode:

If you are deploying to a SQL Server Reporting that is SharePoint integrated, you will need to edit and run the Deploy Reports.ps1. This script must be run from the SharePoint server and must be run from the SharePoint 2013 Management Shell (as an administrator).

Below are the parameters you will need to modify:

Variable Description
$sourceReportsFolder The folder containing the reports to deploy
$ssrsUrl The URL of the SQL Server Reporting Services Web Service
$sharePointSite The SharePoint site that will host the reports
$reportFolder A document library where the reports will be stored
$dataSourceFolder A document library that will contain the data connection file
$dataSourceUrl The URL of the HR SOAP Web Service

Edit the variables with the information that the customer has provided. Note:  $sourceReportsFolder can stay = “.” as everything is stored in the same folder.

Configuration

To configure SSRS, go to the SSRS Definitions on the software application (System Setup > Housekeeping > SSRS Definitions).

From here, enter the information for the applicable fields:

Web Service URL:
This corresponds to the ssrsUrl variable which was set in the scripts above.

SharePoint Integration:
Check the checkbox if you are running SSRS integrated with SharePoint.

Report Builder (optional):
This is the path to the Report Builder or Business Intelligence Studio. Specifying this will enable you to create a new SSRS report from the Queries section.

Standard:
This corresponds to the reportFolder variable which is the folder that the reports were deployed to.

Queries:
Specifying a folder path will display the SSRS reports within the queries ribbon.

Module Reports Folder:
Specifying a folder path will display the SSRS reports within each module.

In order to see the changes take place, you will need to log out, and log back into the application.

Testing

In order to see if the deployment and configuration of SSRS was successful, you will need to perform a test. Go to the following area of the software:

Payroll > Reports > Analysis Reports > Employee Payroll Summary

From here, if the SSRS Viewer radio button is enabled, and you are able to select a report, this indicates that the SSRS integration is working correctly. Now, select a report to run and click OK. An SSRS report should be produced, therefore proving that the configuration of SSRS was successful.

Troubleshooting

Permission Errors

If you are having permission errors when running the deployment scripts, ensure that you are running the scripts as an administrator, and you have the appropriate permissions to create items within SSRS. If SSRS is SharePoint integrated, ensure that you have the appropriate permissions to create document libraries.

401 Unauthorized Error

If the HRSOAP Web Service is hosted on a different server from the server that hosts SSRS, then you will need to ensure that Kerberos has been configured:

https://blogs.technet.com/b/askds/archive/2008/06/13/understanding-kerberos-double-hop.aspx

https://msdn.microsoft.com/en-us/library/cc281253.aspx

The simplest solution to this issue would be to move the HRSOAP Web Service to the same server as SSRS.

Cannot Convert Claims Identity to a Windows Token.

If you get this error, ensure that the “Claims to windows token service” option is turned on. If this, or any other, service needs starting, do it through SharePoint:

https://msdn.microsoft.com/en-us/library/hh231678.aspx