***Insights Miscellaneous Tips

Number of Hours (rounded to quarter hour)

Iif([is_all_day], 24, Ceiling(ToDecimal(DateDiffMinute([start_time],[end_time]))/15)*25/100)

Format String

Parameter date range applied to report.  Generally displayed in report output under the Title in the Report Header.  Note: the parameter names have to be spelled and capitalized to exactly match the ones you created.  See also: Format String Editor

FormatString('Events Booked by Lead Source from {0:MM/dd/yyyy} to {1:MM/dd/yyyy}', [Parameters.DateStart], [Parameters.DateEnd])

Criteria Language Syntax

The Cross-Platform Class Library provides criteria language that you can use in various DevExpress products for building expressions. 
Use sparingly and with caution: Criteria Language Syntax

Example of aggregating contact data into the group header section:

• ^ represents the parent (group event_id matches the detail event_id)
• role is Client
• Max causes only one of the detail items to be selected

[][[^.event_id] == [event_id] && [role] == 'Client'].Max(FormatString('{0}, {1}, {2}', [contact_name], [contact_phone], [contact_email]))

Groups

See also: Group Data

Group Fields

• Open the gear icon, then click on the white on the left side of the group header.
  • If your report does not yet have a group section, create it via the "Actions" section icons (Insert Group Header Band icon)
• Open the Group Fields and hit the plus and select the option to sort by:
  • ^ Ascending
  • v Descending

• You can group by multiple fields at once by making a calculated field
  • For example, if you want to create a list of functions grouped by Event Name in Date order, you'll start by creating a calculated field called EventDateSort with the expression as:  FormatString('{0:yyyyMMdd} {1}',[start_date_time], [vw_events_name])
  • Then click the white space in the Group Header band and expand Group Fields and the + sign, then group by EventDateSort

---

Count of events on the group header:

sumCount([vw_events_event_id])

Example 1 - List of Events by Event Type

Formatstring('{0}, {1}', [vw_events_event_type], sumCount([vw_events_event_id]))

Example 2 - List of Event by Event Manager

Formatstring('{0}, {1}', [vw_events_event_manager_name], sumCount([vw_events_event_id]))