Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Period: Two date fields which you can use to set a date range to select only the data related to specific time interval.
  • On Date: The date for which the data is collected or calculated.
  • Parameters: Can be presented as check boxes for selecting various options or fields for selecting specific objects. By selecting parameters, you can narrow the scope of data in the report.
  • Filters: By using filters, you can select a single or multiple specific system objects or master records to show in the report only the data associated with them.
  • Group by: By using controls of this type, you can rearrange data in the report and add or remove levels of details.
  • Selected Fields: By using controls of this type you can remove or add report-specific columns (fields) to the report print form.

Setting up Filters

Click Filters to make the filters available. You can select any combination of filters to include into the report only the data that you need at the moment.
To set a specific filter—for instance, Company—add companies whose data you need to view.

If you need to add only one company for filtering, click the button. This opens the Companies list from which you can select one company.
To be able to select and add multiple companies at once, click the Pick button. This opens the Companies list from which you can select as many companies as you want. You can view a filter with multiple companies on the screenshot above (Figure 1).
Once you select a company or companies, the Company check box becomes selected to indicate that this filter is active. To delete a company from the list, click the button.
To cancel filtering by companies, clear the Company check box (the filter's text box will keep the list of companies until you change it).
The functionality of other filters is similar to that of the Company filter.

Using Groups

If you want to rearrange the data in the report, click Group By to make the grouping parameters available.

...

There can be more than two options in the Group by list. The grouping is performed starting from the selected option which is the lowest in the list.

Selecting the Fields

Click Selected Fields to open the list of columns/fields that either can be shown in the report or excluded. To include specific columns/ fields in the report, make sure that check boxes for these columns/ fields are selected. To exclude (hide) specific columns/ fields, clear the check boxes for these columns/ fields.

...