Modificare i rapporti
Imparare ad aggiungere e rimuovere oggetti da un report esistente.
È possibile modificare i rapporti standard esistenti e quelli creati in Report Designer. Le modifiche comprendono, a titolo esemplificativo, l'aggiunta e la rimozione di oggetti di report, l'ordinamento di report e la formattazione di report.
To modify reports, you must:
- Appartenere a un'istituzione con un abbonamento a Report Designer.
- Al nome utente sono assegnati i seguenti elementi:
- Un ruolo di Report Designer
- Un ruolo di autorizzazione per Reports e Report Designer per la categoria di report (ad esempio, Acquisizioni, Circolazione, ecc.) che si desidera modificare.
Modify report objects
Aggiungere un oggetto di report a un report esistente
- 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.
Rimuovere un oggetto di report da un report esistente
- Click Reading () in the upper-right corner of the open report to switch the report display to Design mode.
- (Facoltativo) Fare clic su Continua nella finestra Seleziona ambito report.
- 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 modify contains any Totals, verify that the report object you 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 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.
Sort the data in a report
You can sort the data in the report using the Data tab button in the Build side panel. By default, report columns are sorted in ascending order.
Select a different sort order
- From the open report, select the column to which you want to apply a sort order.
- Click the Build side panel button () and then the Data tab button () to open the Data tab. The Data tab opens with the Sort panel displayed by default.
- From report object button in the Sort panel:
- Click the Sort button () to switch the sort to descending order.
- Click the Sort button again to switch the sort back to ascending order.
Work with sort options
Add a new sort option
- From the open report, select the column to which you want to apply a sort order.
- Click the Build side panel button () and then the Data tab button () to open the Data tab. The Data tab opens with the Sort panel displayed by default.
- Select a report object from the Add a sort drop-down list.
- From report object button in the Sort panel:
- Click the Sort button () to switch the sort to descending order.
- Click the Sort button again to switch the sort back to ascending order.
Create a custom sort order for a sort option
Custom sort options allow you to define your sort order.
- From the open report, select the column to which you want to apply a sort order.
- Click the Build side panel button () and then the Data tab button () to open the Data tab. The Data tab opens with the Sort panel displayed by default.
- Click the More options button () on a report object button.
- Select Create Custom Order from the More options pop-up menu. The Custom Order dialog opens.
- From the Custom Order dialog:
- Drag and drop available sort values to reorder the list
Or
Select a value and then click the up or down arrow to reorder the list. - (Optional) Enter a value in the Value to add in list text field and then click the + Add Value button to add the value to the list.
- Click OK to apply your custom order. All tables in the report that use the report object inherit your custom order.
- Drag and drop available sort values to reorder the list
Remove a custom sort order
- From the open report, select the column to which you applied a custom sort order.
- Click the Build side panel button () and then the Data tab button () to open the Data tab. The Data tab opens with the Sort panel displayed by default.
- Click the More options button () on a report object button.
- Select Create Custom Order from the More options pop-up menu. The Custom Order dialog opens.
- Click Reset in the Custom Order dialog. Your custom sort order is removed automatically.
Remove a sort
Remove a sort option
- From the Sort panel, click the report object you want to remove as a sort option.
- Click the Remove sort button (). The sort option is removed immediately.
Clear all sorts
To remove all sorts from the report:
- From the Sort panel, click the More options button ().
- Select Clear All Sorts from the More options pop-up menu. All sorts are removed from the report immediately.