Skip to main content

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 days and 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.
View employee bank details reportsAccess standard bank details reports.
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. Unable to click on the icons when trying to open a 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.
Connect Crystal reports (Hosted by Access)Create a database connection for Crystal Reports Developer report writer for Hosted customers.
An employee is missing from a custom crystal reportEmployee is not visible in a custom crystal report.
Run a data export definition from the websiteAdd the ability to run a data export directly from the website.
Error when editing a data export: Conversion failed when converting date and/or time from characterError when editing criteria in a data export.
Error when running report: Service unavailableError message when running a crystal report via the website.
Standard employee reportsReports available in the employee folder of the document store.