The Calendar layout type places "events" on a calendar:
NOTE: The report shown on this page called 'Example - Calendar', can be downloaded as part of the Example Reports package. However, please not that the example report uses hard coded data as no meaningful start and end fields exist in the basic fields for RMTrack.
Each row of the SQL Query result set becomes an "event" on the calendar.
Result set column
Meaning
id
String - Optional - Uniquely identifies the given event. Different instances of repeating events should all have the same id.
title *
String - REQUIRED - The title of the event displayed on the calendar.
start *
Date/time - REQUIRED - The date/time an event begins on.
[end] *
Date/time - REQUIRED - The date/time an event ends on. (Square brackets required)
allDay
bit (1 or 0) - Optional - Indicates whether or not the event is for the entire day or only a portion of the day.
url
String. Optional - The url the browser is sent to when the event is clicked.
backgroundColor
String. Optional - The background color for the event.
borderColor
String. Optional - The border color for the event.
textColor
String. Optional - The text color for the event.
className
String. Optional - A css classname for the event
* The minimum columns in the result set to create events on a calendar are: title, start and [end].
