Advance Report Expressions (Row Grouper Examples)

Examples of some expressions you can use when writing in the Advanced Report.

 Instructions

Example you can use for the Row Grouper

This is how the information is grouped/filter (Use only specific calltype/assets etc..)

• Sort by Crew Type (Resident in Example)

CASE WHEN (data('request crew type') = 'Resident')

THEN data('request crew type')

ELSE ' '

END

• This is an example of grouping Call Type

Case when data (id, ‘request call type') in ('Interfacility - Ground', 'Interfacility - Rotor Wing','Interfacility - Fixed Wing','Scene’) then data (id, 'request number') else null end

• This is an example of grouping by Patient Number

Case when data ('transfer item number') like 'TC%' then data (id, 'transfer item number') else null end

• This is an example of filtering a Facility as Requestor or Reciever

case when data ('patient leg requestor') = 'Hospital Name' or data ('patient leg receiver') = 'Hospital Name' then
data ('request number')
else null end

Related Articles:

Advanced Report Expressions (Examples for Columns)

Advanced Report Expressions (Pickup/Drop off SQL Times)

Advanced Report Expressions (Other Examples)