Chat now with support
Chat with Support

Welcome, erwin customers to Quest Support Portal click here for for frequently asked questions regarding servicing your supported assets.

MessageStats 7.6 - Report Pack for Lotus & IBM Notes User Guide

About the Lotus and IBM Notes Report Pack Preparing for Installation Configuring the Report Pack Database Management Setting Task Default Properties Creating Gathering Tasks Using the Reports Console Lotus and IBM Notes Report Descriptions Report Filter Definitions

Using the Edit Button

An Edit button is located at the right side of each folder and report in the file-based model. The commands available on the Edit button differ depending on whether the Edit button is accessed from a folder or a report.

For folders, the following commands are available:

Copy To

Opens a dialog box for you to define the destination of the copied folder.

Move To

Opens a dialog box for you to define the destination of the moved folder.

After the report is moved to the new location, the original is deleted.

Rename

Opens a dialog box for you to rename the selected folder.

Delete

Prompts you to verify that you want to delete the folder.

Edit Description

Opens a dialog box for you to edit the description of the folder.

For reports, the following commands are available:

Copy To

Opens a dialog box for you to define the destination of the copied report.

Move To

Opens a dialog box for you to define the destination of the moved report. After the report is moved to the new location, the original is deleted.

Rename

Opens a dialog box for you to rename the selected report.

Delete

Prompts you to verify that you want to delete the report.

Modify Report

Opens the Web Report Wizard to allow you to make any changes to the selected report, and save your custom report.

Selecting Report Filters

When you select the report you want to view from the treeview, you can select filters before MessageStats renders the report. After the report is rendered, there are two ways to change the filter options:

Select the Show Filters bar at the beginning of the report to change multiple filters.
4
Click Apply Filters.
1
Click Show Filters at the beginning of the rendered report.
3
Click Apply Filters.

Using Quick Filters

Each report can have a Quick Filter bar at the bottom of the page. This bar does not scroll with the report.

=

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.

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.

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.

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 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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating