Skip to main content

Data Management

Export, reports & data audits

Data Export & Reports

Useful data export queries

Find the data location for data export fieldsFind the location of a field to add to a data export.
Create a data exportGuidance on creating custom data exports.
Locate and run a standard report
Create a custom report or data exportCreate a new report or export.
Pay related reportsStandard pay history reports available in the document store.
Troubleshoot Bradford Factor calculationsSteps to troubleshoot an incorrect Bradford Factor score.
Data Export: Emergency contact informationData export to show all emergency contacts.
Data Export: Exit Interview informationReporting on Exit Interview information.
Data Export: Current employee detailsData export to show basic employee details.
Standard Holiday reportsStandard holiday reports available in SelectHR.
Data Export: List of leaversData export to show a list of leavers.
Run GDPR reportsRun GDPR related reports
Identify the schema, table and key number for use in an audit exportInformation on how to find fields to include in a data export
Data Export: Employees and their assigned working patterns/schedulesData export to show all employees with their working pattern and schedules.
Data Export: Employee passport numbers & expiry dates
Data Export: All users and their last login time and dateData export to show all users and the last time they logged into SelectHR.
Data Export: Pending/Outstanding holiday requests for employeesData export to show all pending holiday requests.
Turnover and headcount reportsTurnover and headcount reports explained.
Data Export: Employee holiday entitlementData export to show hours taken and remaining for each employee.
Data Export: All holiday rule overrides on career history recordsData export to show all employee's who have a career level holiday rule override.
Export definition error: Incorrect syntaxError message when creating a data export: Incorrect syntax
Data Export: All running absence workflowsData export to show all running workflow.
Unable to click Import/Export dataImport/Export data option is greyed out.
Data Export: Employee addressesData export of all employee addresses.
Data Export: Employee absence history recordsData export to show absence history for an employee.
Data export advanced filters
Error opening crystal report: Failed to open the connectionError opening crystal report: Failed to open the connection.
Crystal Reports: Application crashes when clicking open or saveApplication crashes when trying to open or save a crystal report.
Save a data export onto a local machine or network drive instead of the hosted environmentUnable to save a document on PC when hosted.
Calculations in Sickness and Sickness Cost ReportsCalculations used in the sickness cost reports.
Data export tipsUseful tips to help when creating a data export.
Error when trying to open non-default Crystal Report added to the website: You may not have permissions, or an error may have occurredUnable to open all reports: You may not have permissions, or an error may have occurred.
Error when saving export/performing an import: This operation has been cancelled due to restrictions in effect on this computerError message when selecting a file for a data import.
Bradford Factor ReportsStandard Bradford Factor reports available.
Bank Detail reportsStandard Bank Details reports available in SelectHR.
Restrict access to data within a crystal reportRestrict access to data within a standard crystal report. Allow managers to only see their employees in a report.
Review the work email assigned to all person recordsData export to show the email addresses of all person records.
Reports failing when run from a batch job: The report to run has not been specified or could not be found.Reports failing when run from a batch job: The report to run has not been specified or could not be found.
Error when trying to open a data export: Conversion failed or Execution Timeout ExpiredUnable to open a data export in the admin tool.
Clicking view document fails to load Crystal Report or documentWhen clicking on a report to run, nothing happens; it fails to load with no error message.
Error when exporting a Crystal Report: The system cannot find the path specifiedError when exporting Crystal Report: The system cannot find the path specified
Data Export: All users, their assigned menu sets and assigned rolesData export to show all users, their assigned menu sets and assigned roles.
Unable a open report from custom buttonUnable a open report from custom button which has been added to a menu set.
Gender Pay Gap reportingConfiguring your system for Gender Pay Gap reporting.
Data Export: All pay changes submitted to SelectPay for a specific employeeSee what pay information been submitted to SelectPay for an employee via a data export.
Data Export: Overlapping absence data exportData export to show overlapping absences.
Unable to open reports or choose date parametersUnable to choose a date when opening a crystal report.
Export or import Crystal reports in a hosted environmentExport, import and edit crystal reports in a hosted environment.
Error when opening reports: The report could not be loaded. You may not have permission.Unable to open reports from the website.
Data Export: Auditing User Account logins, Menu Set & Group AssignmentsData Export: Auditing User Account logins, Menu Set & Group Assignments.
Create a data audit exportCreate a data export to identify who has inserted, updated or delete a record.
Starters reportsStandard reports available to view new starter information.
Standard leaver reportsStandard reports for leaver details.
Equality and Diversity reportsStandard reports for equality and diversity.