Create a calendar report in the Report Builder

Create a calendar report to show and highlight date-driven events.

Create a calendar report in the Report Builder

Create a calendar report to display date-driven events on a calendar.

Before you begin

Role required: itil, report_group, report_global, report_admin, or admin. To create a meaningful report, you must have the right to access the data you want to report on.

About this task

This task refers to using the Report Builder (Classic UI) in the Kingston release under UI15 and UI16. If you are using the Report Designer, see Create a calendar report in the Report Designer.
Report Designer UI Report Builder UI
Report designer UI example Report builder UI example

Procedure

  1. Navigate to Reports > Create New.
  2. Fill in the fields, as appropriate.
    Field Description
    Name Enter a name for the report.
    Detailed description Click this icon to enter a report description.

    This description appears when users point to the question mark icon (Question mark icon) for the report when the report is on a dashboard in the edit mode.

    Data Select the table or report source containing the data that you want to report on.
    Type Select Calendar.
    Calendar by Select the type of date-driven event to display on the calendar.

    For example, select Planned end date to view events on the date that they are scheduled to end.

  3. Click Run to view the calendar report, or click Save to save the report.

Result

The report is generated.
Note: When there are more events on a date than fit in the calendar cell, a link is shown to view the additional events.

Calendar cell with two extra events, also shown expanded

If there are more than thirty events, the cell shows + many. Click this link to show all the events in a list view for that date.

What to do next

Disable new calendar reports

To use the version of calendars from releases prior to Helsinki, disable the new calendar version. Reasons to use the old calendar include having scripts that are incompatible with the new calendar and preference for the style of the older calendar. The updated calendar is also not supported in Internet Explorer versions 7 and 8.

Before you begin

Role required: report_admin or admin

Procedure

  1. Navigate to Reports > Administration > Properties.
  2. Add the glide.report.new_calendar system property, and set it to false.
    See Reporting properties.
    Note:

    If this system property is set to true, it is supported only in the classic UI. Click Switch to classic UI in the report designer.