MessageStats 7.8 - Reports User Guide

Table 12. Parameters available for the report quick filters.
Parameter	Available IN	Description
=	All	The field value equals the criteria value.
<>	All	The field value is not equal to the criteria value.
>	All	The field value is greater than the criteria value.
<	All	The field value is less than the criteria value.
<=	All	The field value is less than or equal to the criteria value.
>=	All	The field value is greater than or equal to the criteria value.
like	All	The field value is like the criteria value.
is NULL	All	There is no value for the criteria field.
is not NULL	All	There is any value except NULL for the criteria value.
between	All	The field value falls between the two criteria that you define.
is in	All	The field value is in the criteria that you define. When using the is in operator, you can multi-select in the Select a Value dialog box by holding down the CTRL key and clicking the items you want. The selected items appear in the edit box as a list separated by semi-colons.
not in	All	The field value is not in the criteria that you define.
last	Date, DateTime	This operator allows you to select a time interval in the form nn uu, where nn is a number and uu is a unit of time. (For example, Last 5 Weeks, Last 3 days, and so on). The time interval is based on the current time.
most recent	Date, DateTime	This operator queries the database for the most recent entry for the specified field and then uses that value to find all records with a matching value. The value depends on the content of the database and is independent of the current time. “Most recent” could potentially mean a time long past, and remain unchanged until the database is changed.
today	Date, DateTime	Today = from 12:00 AM to the current time.
yesterday	Date, DateTime	Yesterday = from 12:00 AM to 11:59 PM yesterday.
this week	Date, DateTime	Start = Sunday of current week, End = today.
last week	Date, DateTime	Start = Sunday of previous week, End = Saturday of previous week.
this month	Date, DateTime	Start = 1st day of current month, End = today.
last month	Date, DateTime	Start = 1st day of previous month, End = last day of previous month.
this quarter	Date, DateTime	Start = 1st day of current quarter, End = today.
last quarter	Date, DateTime	Start = 1st of previous quarter, End = last day of previous quarter.
Quarters start January 1, April 1, July 1, and October 1.
year to date	Date, DateTime	This operator selects records with dates from January 1 of the current year to the current date.
contains	Description	The field value contains the specified criteria.
does not contain	Description	The field value does not contain the specified criteria.
starts with	Description	The field value starts with the specified criteria.
ends with	Description	The field value ends with the specified criteria.
does not start with	Description	The field value does not start with the specified criteria.
does not end with	Description	The field value does not end with the specified criteria.

Define the filter criteria.

- OR -

Define both criteria if you have selected Between as your report parameter.

Click

Using Save Report Settings

Use Save Report Settings to retain the filter settings, sort and grouping options, and any other modifications that you have made to a report. You can then easily create subsequent reports with similar settings.

You can use the Set Filter Defaults to specify default filter parameters that apply to all MessageStats Reports. You can then modify a report to more closely meet your specific needs by setting additional filters, adding or removing report fields, and changing filter or grouping options.

When you have finished modifying a report, you can use the Save Report Settings option to save the report settings. Each time you run the report, the query uses the settings that you have identified for that report.

Changing Grouping Options

After a report is generated, you can change the grouping options for the report. Each column header provides the facility to change grouping options.

The following illustration shows the grouping options that appear when you right-click the column header. The options that appear depend on the current settings.

Initially, the same options appear regardless of which column header you select. After you change the grouping options, the list changes to reflect your current settings.

Table 13. Available options when you right-click a column heading.
Option	Description
Group By	Groups the report by the selected field.
Ungroup	Removes the grouping of the report by the selected field.
Insert Field	Adds a new field to the left of the selected field. When you select this option, a scrolling list appears for you to select the new field.
Append Field	Adds a new field to the right of the selected field. When you select this option, a scrolling list appears for you to select the new field.
Remove Field	Removes the selected field from the report.
Sort Ascending	Sorts the field in ascending order.
Sort Descending	Sorts the fields in descending order.
Remove Sorting	Removes the sorting that you have indicated from the report.