Amber Reporting Advanced Skills

Amber Reporting Advanced Skills

Re-arranging Columns

Columns can be re-arranged in two ways:

1.  Placing them as required when dragging and dropping the additional objects

2.  Using the Pivot functionality

·  To use the Pivot functionality – Right click a column/field/cell of the table and select Format then Table.

·  Go to the Pivot Tab. You can now select the order of columns simply by scrolling over the field names using the extended right click.

Viewing Column Descriptions

·  To view a brief summary – In the Available Object panel hover the cursor over the desired object name

·  To view the full text of the Object click on the Document Summary section on the toolbar then click “more”

Inserting Breaks

You can use breaks to group common data within each field. Breaks are unique to the column to which you apply them. Applying a break to one column will group the data differently than applying the break to a separate column.

·  Left-click to highlight the column where you would like to insert the break.

·  Right-click the column, point to Break on the short cut menu and then click Insert.

Calculations

You can add mathematical functions and calculations to your report rows and columns. You can apply more than one calculation per report.

·  Left-click the column to which you would like to apply a mathematical function to highlight it.

·  Right-click the column and point to Calculation on the shortcut menu. Choose one of the following options:

·  Sum. Adds the values in the column.

·  Count. Displays the number of entries in the column.

·  Average. Displays the average of the values in the column.

·  Min. Displays the lowest value.

·  Max. Displays the highest value.

·  Percentage. Shows the value’s or sum of value’s percentage of the entire column.

Filtering the Reports

·  Left-click the column you want to filter to highlight it.

·  Right-click the column and click Filter, then Add on the shortcut menu.

·  Your field values will be displayed in the left scrollbar, and your filter operators in the right dropdown.

·  Choose a filter operator from the dropdown.

·  Add and remove the desired field values to the filter box using the arrows in the middle of the screen.

·  Click OK to apply the filter.