Reporting 2.0 Report Details

The Reporting 2.0 Report Details report allows System Admins to extract a list showing all reports that have been created within the portal. This report supports 100,000 rows of data and will include several filter options. Because this is an Admin report, the report will not be constrainable.

To access the Reporting 2.0 Report Details Report, go to Reports > Standard Reports. From the System tab, select the Reporting 2.0 Delivery Log link.​

PERMISSION NAME PERMISSION DESCRIPTION CATEGORY
Reporting 2.0 Report Details

Grants access to view the Reporting 2.0 Report Details, which displays information about the Reporting 2.0 reports created and ran.

The Reporting 2.0 Report Details permission can be constrained by OU and User constraints. The constraints apply to the recipient user.

The Reporting 2.0 Report Details permission will be assigned to the Cornerstone Administrator and System Administrator roles by default.

 Reports - System

Report Output

The following details are included in the report output:

Column Name Description
Report ID This displays the ID of the report.
Report Title This displays the title of the report.
Report Type This displays the type of the e.g. Transcript report, Performance review report etc.
Report Owner User ID This displays the ID of the user who created the report.
Report Owner Username This displays the username of the user who created the report.
Report Owner Full Name This displays the full name of the user who created the report.
Report Owner's Status This displays the status of the user who created the report, if the user is still active / Inactive.
Report Owner's Email This displays the email address of the user who created the report.
Report Modifier User ID This displays the ID of the user who modified the report.
Report Modifier Username This displays the username of the user who modified the report.
Report Modifier Full Name This displays the full name of the user who modified the report.
Report Creation Date This displays the date on which the report is created.
Report Active This displays if the report is active or not.
Report Last Modified Date This displays the date on which the report was modified for the last time
Report Last Run Date This displays the date on which the report was last run.
Report Total Runs This displays the total runs altogether for the reports, irrespective of the date filter 'Report Last Run date.'
Report Columns This displays all the columns (active and inactive) that are mapped to the report separated by pipe separator (|).
Filter Columns This displays all the columns (active and inactive) on which filter is applied for the report separated by pipe separator (|).

 

The following advanced fields are available in the report output:

  • Sorted Columns
  • Summarized Columns
  • Show Distinct Rows
  • Run When Opened
  • Report OU Filter
  • Report User Filter

  • Automation Details

    • Automation Enabled?
    • Automation Type
    • Delivery Format
    • Schedule Recurrence
    • Schedule Start Date
    • Schedule End Date
    • Schedule Time Zone
  • Creator Report Folder Name
  • Migrated from Custom Reports?
  • Include Inactive Reports

  • Report Sharing Details

    • Is Report Shared
    • Report Shared with OU Title
    • Report Shared with OU ID
    • Report Shared with OU - Include subordinates
    • Report Shared with OU - Include Automation
    • Report Shared with OU - Edit Report?
    • Report Shared with User ID
    • Report Shared with User Full Name
    • Report Shared with User - Edit Report?
    • Report Shared with User - Include Automation?
    • Report Shared with User - Include Subordinates?

Reporting 2.0 Report Details Considerations

  • The Report Total Runs column in the report output will show total runs altogether for the reports, irrespective of the date filter Report Last Run date.
  • Date fields are displayed in the time zone of the user running the report.
  • The ‘Report columns’ field in the report output will include both active and inactive columns mapped to a specific report.