Modify reports
Learn how to add and remove report objects from an existing report.
You can modify existing standard reports and reports you have created in Report Designer. Modifications include, but are not limited to, adding and removing report objects, sorting reports, and formatting reports.
In order to modify reports, you must:
- Belong to an institution with a Report Designer subscription.
- Have the following assigned to your user name:
- A Report Designer role
- A Reports and Report Designer authorization role for the report category (e.g., Acquisitions, Circulation, etc.) you want to modify
Add a report object to an existing report
- Click Reading (
) in the upper-right corner of the open report to switch the report display to Design mode. - Click the Edit button (
) in the Query tab to open the Query Panel dialog. - Double-click the report object you want to add to the report to add it to the Result Objects panel.
- Click Apply and Close to close the Query Panel.
- Add the newly added report object to the report using one of the following methods.
- Locate the newly added report object in the Document dictionary pane of the Main panel and drag it to the position you want to place it in the report.
- Right-click an existing column in the report, click Insert > Columns on Left or Column on Right, and then drag the report object to the newly created column.
- Click the Refresh all refreshable data providers button (
) in the Query table to populate the newly added column. - Click Save to save the updated report format.
Remove a report object from an existing report
- Click Reading () in the upper-right corner of the open report to switch the report display to Design mode.
- (Optional) Click Continue in the Select Report Scope window.
- Right-click a row in the column containing the report object you want to remove and select Delete. The column is removed from the report.
- Right-click and then click Delete. The column no longer appears in the report.
Note: If the report you are modifying contains any Totals, verify that the report object you have removed is not included. To verify:- Click in a Total data cell.
- Click the Formula bar button (
) in the Analyze tab to show the formula bar. - If the formula contains the deleted report object, remove the report object from the formula and click OK.
- Right-click in a Total/Totals data cell and then click Content > Edit Content to view the formula.
- If the formula contains the deleted report object: Remove the report object from the formula in the Edit Formula screen and click OK.
- Repeat step 4 for the remaining Total data cells.
- Click Save to save the updated report format.