Variabili del rapporto
Imparate a usare le variabili e gli oggetti dei report per creare formule predefinite e riutilizzabili in Report Designer.
Overview
When modifying a standard or new custom report, you can create a report variable. Report variables allow you to:
- Creare formule riutilizzabili e predefinite utilizzando gli oggetti del report.
- Eseguire una formula in Report Designer invece di esportare i dati in Excel per eseguire le formule.
Nota: le variabili del report sono disponibili solo con Report Designer.
Creare una variabile di report per un report standard o personalizzato
- Click Reading in the upper-right corner of the open report to switch the report display to Design mode.
- Click the Add a new variable button () in the Objects tab of the Main side panel. The Create Variable dialog opens.
- Nella finestra di dialogo Crea variabile:
- Enter a name for the variable.
- (Optional) Click the Show/Hide description panel button () to open the Description text field and enter a description for the variable.
- Select the type of variable you're creating from the Qualification drop-down list.
- Dimension (default)
- Misura
- Detail - If selected, click the Display list of dimensions button (), select an associated dimension from the Objects and Variables dialog, and click OK.
- Enter the formula for the variable in the Formula pane by double-clicking objects in the following panes.
Note: When available, single-click an object, function, or operator value to view its definition beneath the Formula pane.
- Oggetti
- Functions
- Operators - You can choose from the list of available values to insert values for a particular report object into the variable formula. After you have added a report object from the Objects pane:
- Click the Show operators list button ().
- Double-click an operator in the Operators pane to add it to the formula.
- Click the Validate formula button () to validate your formula.
- If your formula fails validation, you will receive a warning message about your error(s).
- Click OK to close the warning message dialog.
- Edit your existing formula or click the Cancel formula button () to start over.
- If your formula fails validation, you will receive a warning message about your error(s).
- Click OK to save your variable.
Cancellare una variabile del report
È possibile eliminare le variabili dai report standard o personalizzati.
- Click Reading in the upper-right corner of the open report to switch the report display to Design mode.
- Click Dimensions in the Document dictionary pane of the Main side panel to collapse the accordion.
- Select the variable you want to delete from the Variables accordion.
- Click the More options button () and select Delete from the pop-up menu. The Warning dialog opens.
- Click OK in the Warning dialog. The variable is automatically deleted.
Modifica di una variabile del report
È possibile modificare le variabili dei report standard o personalizzati.
- Click Reading in the upper-right corner of the open report to switch the report display to Design mode.
- Click Dimensions in the Document dictionary pane of the Main side panel to collapse the accordion.
- Select the variable you want to edit from the Variables accordion.
- Click the More options button () and select Edit from the pop-up menu.
- Edit the variable as desired.
- Click OK to save your changes.