Reports with Breaks

WOW combined with SQL allow the quick creation of real time data operations. Consider this example of an operation that displays employee salary information by department:

You want to include total salary by department in your data report. WOW provides a property group called ReportBreak that allows you to create enhance reports that include column counts, summaries, min, max and other functions.

By default WOW will return data without these breaks as shown below.

To include the report breaks you must first open the operations. Scroll down to the display section and find the properties.

Reports are another important feature of WOW. Reports are used to perform different mathematical operations on the

data in the table. Reports will find the minimum, maximum, sum, or average of any numeric data that is in the table.

With a simple SQL command, the information in the table can be sorted out by specific groups such as work

department or gender. The syntax is:

ReportBreak {}

In between the open and closed brackets, any of the following properties may be added. Property names must be

followed by a colon, the property values should be separated with a comma, and end with a semicolon. For example:

ReportBreak { columnFunctions:max; columns:salary,comm; breakColumns:workdept; overall:false;}

Once you have updated the operation, refresh the application and the reports will appear, as shown below. You can see that the average and sum are being calculated by department.