As part of the Company’s corporate SharePoint portal evolution and introduction of HRM-functionality the decision was made to develop reporting system with the ability to download detailed employee data.

Service development goal was to provide users with the ability to generate reports using various filters and data views.

Module specifics:

• A large number of reports;
• Inability to implement required data aggregation using standard SharePoint tools;
• Calculated fields in reports depending on certain rules and conditions.

The following reports were implemented within project scope:

• Labor book log
• Employees on probation
• Sick leaves
• Employee’ documents
• Salary changes
• Work trips
• Health insurance
• Job locations
• Vacations
• Trainings passed
• Employment contracts
• Employee’ marital status
• General monthly report
• Schedule of positions and salaries
• Leave balance

Development specifics:

• Module is based on SQL Server Reporting Services Platform;
• A special web service performing server-based searches was developed to fill reports with data. Upon report opening Reporting Services platform calls certain web service methods passing report parameters to them. Methods collect and aggregate the data and return it using xml;
• Client part of the system uses this data to create reports for end users.

More than 20 reports of varying complexity were created. Now it is possible to aggregate information and obtain reports on more than 700 Company employees.