Return to main navigation Page
This article assumes you have already created a new report or you are editing a report.
Each Report can have two types of criteria: Standard and Advanced. Results are generated based on transactions that satisfy both of these filter requirements.
The Display Columns section allows the user to build the data that is displayed when the report is run. The user can select attributes to display and specify the way in which the columns must be grouped. The user can choose to display some values that are calculated from numeric/currency attributes that are returned.
These filters include the following:
|Currency||You can filter by document currency. Reports can return transactions in ALL currencies, as long as the user does not perform any operation, like sum, average, and so on, on a Currency type attribute, use that attribute in a calculated column, or use a Currency type attribute in a Group By. In these cases, the user must select a specific currency.|
|Date Filter||This filter is mandatory. Standard dates that can be used to build reports are Date Created and Date Last Modified. Additionally, users can choose any custom commerce Date attributes that have been mapped to the Data Columns, such as Expiration Date.|
|Duration||This filter is mandatory. You can choose the duration for the date chosen in the Date Filter.|
In relation to duration, remember that a week is considered to begin on a Sunday and end on a Saturday. You are allowed to set the beginning of a fiscal years in the Process Administration editor. All Fiscal durations will be based on this date.
Creating Advanced Filters
The user can define advanced filters on all main-document, sub-document and configurable Text, Numeric, Currency, Date and Menu type attributes that have been mapped to Data Columns.
Click Add Row.
Click on the drop-down under Attribute and choose the attribute you'd like to filter by.
Set the Row Grouping, for multiple attributes. If left blank it will default to AND ALL.
Setting Displayed Columns
Once you have created your standard and advanced filters, you will need to define at least one main-document display column in order to run the report. Failure to do so will result in an error message.
You can select from three options:
A green arrow next to the attribute name means that the attribute can be placed in the position you’ve selected. A red NO sign will appear next to the attribute if it is not allowed.
Set display column options:
|Column Type||What Does It Look Like?||Options||Notes|
Format: Switch between the Number and Currency formats. If the Number format is selected, another option will appear allowing you to set the number of decimal points.
Display On: Specify at which group level the column should be displayed.
Edit: Make changes to the calculated column.
|Non-Numeric Quote and Line Item Attributes||
Display as Link: Displays the attribute as a link that when clicked, takes you to the quote.
Group: Determine if this attribute should be used to group the rows. Doing so will remove the attribute as a Display Column. For example, you can group quotes by their Submitted Date or by Selected Currency.
Remove: Click to remove the column from the Display Columns panel.
|Numeric Quote and Line Item Attributes||
Sum: Reflect the sum of the aggregate for an attribute. For example, , Quote Totals.
Average: Reflect the average for an attribute.
Minimum: Reflects the minimum value of all Quote Totals for a group. If there are three quotes ($145,694.23, $34.56, and $35, 434), the minimum will find $34.56.
Maximum: Reflects the maximum value of all Quote Totals for a group. If there are three quotes ($145,694.23, $34.56, and $35, 434), the maximum will find $145,694.23.
|All numeric quote and line item attributes have the ability to be displayed as aggregates. Aggregates are used in conjunction with Groups to provide data on the x-axis of charts. in this example, you will see the options for the attribute Quote Total.|
Group your attributes into rows. This will remove them from the Display Columns header and place them below.