This topic explains the simple changes you can make to a report without having to learn all the functions of the Report Builder. This topic covers how to:
Important Note: There is no 'Save As' function when editing an existing report. When you are finished editing the report (whether a public or private report), your only options are to save and override the original report or to cancel all your changes. If you are not sure you want to overwrite an existing report, then make a duplicate (copy) of the report first and then edit the duplicate. Note that a select number of reports cannot be edited. Editing a report:All editing begins with the same instructions... |
Select Reports from the menu (Menu > Views tab > Reports).
Click either on the Public or Private tab.
Select the report and click the Edit icon located next to the report's name.
This brings up the Report Builder and its 5 tabs.
The following explains how to make changes to Standard Type reports (the most common type used). Instructions for changes to other report types (Pie, Bar, Grid or Raw Data) vary slightly and can be easily figured out from the following examples and a little bit of experimentation.
Remove a column
From the Columns tab.
In the Selected Columns list box on the right, click on the data field/column to remove.
Click the Remove arrow button located between the lists.
Click the Run Report button to see the change.
Click Save.
If editing a public report, you are prompted to override the original report.
Change the order of columns in a report
From the Columns tab.
In the Selected Columns list box on the right, click on the data field/column to move.
Use the up/down arrow buttons to re-position the column within the report. The topmost column is displayed at the far left of the report (unless Grouping is used).
Click the Run Report button to see the change.
Click Save.
If editing a public report, you are prompted to override the original report.
Add a column
From the Columns tab.
In the Columns list box on the left, locate and click on the data column to add. A complete list of column data fields is located here.
Click the Add arrow button located between the lists to move the column to the Selected list.
Use the up/down arrow buttons to position this new column within the report.
Click the Run Report button to see the change.
Click Save.
If editing a public report, you are prompted to override the original report.
Add a footer
Run the report.
From the Preview toolbar, click the Footer button .
Click the radio button next to the empty text box.
Enter the footer text (95 characters maximum). Note that the footer is only applied to this report.
Click Apply.
Click Save.
If editing a public report, you are prompted to override the original report.
Adjust column widths
Run the report.
From the Preview toolbar, click the Set Column width button .
For each report column, use either the Auto width option or manually type in a new width - in pixels.
Click Apply
Click Save.
If editing a public report, you are prompted to override the original report.
Change the report name or description
Click on the General tab.
Edit the Report Name and Description as required.
Click Save.
If editing a public report, you are prompted to override the original report.
Also
Making a report public - Available to all administrative users
Changing the filters displayed when running the report