| #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index |
|
Read More |
You can use a Variable from the Asset Repository in the filtering condition of a Worksheet Data Table, Named Condition, or Named Grouping. Follow these steps:
1. Drag the Variable from the Asset Repository into the Worksheet where it will be used.
2. Open the 'Conditions' dialog box for the table, Named Condition, or Named Grouping.
3. Select the 'Variable' option, and choose the desired Variable from the menu.
When you bind a Variable to a table in a Worksheet (either directly through the table's filtering condition, or indirectly through a Named Condition or Named Group that is linked to the table), a user will be prompted to supply the Variable value when they do one of the following things:
• Open the Worksheet in Visual Composer or Asset Composer
• Save the Worksheet in Visual Composer or Asset Composer
• Click the 'Enter Parameters' button in the Worksheet toolbar
• Open or preview a Viewsheet linked to the Worksheet (only if Viewsheet's 'Disable Prompt Parameter' option is deselected, and no default is specified for the Variable)
• Open or preview a report that uses the table linked to the Variable
To use a Named Grouping from the Asset Repository in a Worksheet table, follow these steps:
1. Drag the Named Grouping from the Asset Repository into the Worksheet where it will be used.
2. Select the Named Grouping from the grouping options in the 'Aggregate' dialog box.
To use a Named Grouping from the Asset Repository in the data binding grouping of a Report, select the Named Grouping from the 'Predefined Named Group' menu.
To use a Date Range from the Asset Repository in the filtering condition of a Worksheet table, follow these steps:
1. Drag the Date Range from the Asset Repository into the Worksheet where it will be used.
2. In the 'Conditions' dialog box for the table, select the Date Range from the 'in range' menu.
To use a Date Range from the Asset Repository in the data binding condition of a Report, select the Date Range from the data binding condition 'in range' menu.