Start a conversation

Reporting

  • SQL - Count Booking Header Status change

    The SQL query below can be used to count how many 'Booking Header' status change records have been created by each user in a given date range. Simply cut/paste the query text below into the SQL tool, ...

  • SQL - Count Candidates by Status

    The SQL query below can be used to count how many candidates there are at each Status. Simply cut/paste the query text below into the SQL tool, and give the query a NAME so that you can save it. Query...

  • SQL Report - Count Cancelled Bookings by User

    The SQL query below can be used to count how many cancelled bookings exist from a particular date, and give a total per user. Simply cut/paste the query text below into the SQL tool, and give the quer...

  • SQL Report - Find Candidate by Booking Ref

    The SQL query text below can be pasted into the SQL query tool. Simply replace the 'BOOKING_ID' selection field at the end, with the booking ID you are searching for. Query Text SELECT BKNG_DATE, BKNG...

  • Margin Report

    Margin Report A new Margin Report has been added to the software and will be available after version 1.00.17.213 The report will allow users to generate a report showing the TOTAL Margin between two d...

  • SQL Query Tool

    SQL Query Workbench A new reporting tool has been added to the system after release 1.00.17.052 It allows users to write SQL queries and return results from the database. These results can then be exp...

  • Compliance - Job Specific Compliance Items

    Job Specific Compliance Items It is possible to setup compliance items to apply to a specific Work Type so that it will only apply to Role Codes which have been assigned to this Work Type. It is also ...

  • Favourite Views

    Favourite views Favourite views are a quick and easy way to setup particular views of the database and also allow users to easily export data in the form of lists or reports. By selecting suitable fil...

  • How Do I - Use and Produce KPI Data

    Your Influence software has an in-built KPI (Key Performance Indicator) reporting function. This allows users to analyse figures stored by the system for rates such as Candidates added, Clients added,...