...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Filter Bar Anchor Filter Bar Filter Bar
Filter Bar | |
Filter Bar |
You can use the filter bar on any report to customize your view of the data already returned based on the prompt answers you selected.
...
Enabling the Filter Bar Anchor Enabling Enabling
If a report was built with the filter bar enabled, you can skip this step. After running the report:
- Click Filter Bar on the top toolbar.
- The Filter Bar will display under the top toolbar. See Figure 1.
Figure 1: Filter Bar. Click image to enlarge.
...
Adding Objects to the Filter Bar Anchor Adding Objects Adding Objects
Adding Objects | |
Adding Objects |
- Click the Filter Bar icon for a list of objects the can be filtered.
- Navigate through the grouping sections with an arrow. See Figure 2.
Figure 2: List of Object Filters. Click image to enlarge. Select the object you want to filter.
A drop-down box of the object values will appear on the bar, but the data on the report hasn't been filtered yet.
Note | ||
---|---|---|
| ||
You may add as many objects into the filter bar as needed. |
Excerpt |
---|
...
Selecting Values for |
...
the Object in the Filter Bar Anchor |
|
...
Removing Objects from the Filter Bar Anchor |
|
Anchor Input Controls Input Controls
Input Controls
Input Controls | |
Input Controls |
Input controls are only available on reports where they were included during the design phase. Input controls are another way to filter the data you see on a report or within a document based on the prompt answers you selected.
Opening the Input Controls Anchor Opening Opening
Opening | |
Opening |
If your Input Controls toolbar is already expanded, you can skip this step.
- Click on the Input Controls icon on the left-hand toolbar.
- The Input Controls details specific to your document and report will expand. See Figure 4.
Figure 4: Input Controls Details. Click image to enlarge.
Using Input Controls Anchor Using Controls Using Controls
There are various types of input controls. You will need to interact differently with each control. See Figure 4 for examples.
Controls can affect different portions of the report:
- Document Input Controls - Choosing a value on these input controls will filter all tabs in the document.
- Report Input Controls - Choosing a value on these input controls will filter data on only the current tab or select elements in this tab.
Figure 5: Different scope of Input Controls.Click image to enlarge.
Note | ||
---|---|---|
| ||
You can use multiple input controls together to further refine the data you are |
...
viewing. |
Clearing Input Controls Anchor Clearing Controls Clearing Controls
You can choose to clear individual Input Controls or all Input Controls.
- Individual Input Controls - Click the Clear Filters button or select All Values from the Input Controls values list.
- All Input Controls - Click the Reset button at the top of the Input Controls detail panel. This will either set the control to it's default state or clear it.
Interactive Filters
Interactive Filters are only available on reports where they were included during the design phase. Interactive Filters are the third way to filter the data you see on a report or within a document based on the prompt answers you selected.
Identifying Interactive Filters Anchor Identifying Identifying
Identifying | |
Identifying |
- The Interactive icon appears to the upper right of those elements of a report that can be used to filter or adjust other elements of that report.
- To determine which elements are controlled by that Interactive Filter:
...
- Click on the Input Controls icon on the left-hand toolbar. If your Input Controls toolbar is already expanded, you can skip this step.
- Click on the Map button at the top left corner.
- A list of Input Controls and the affected reporting elements are presented, with the current report items expanded for viewing.
Using Interactive Filters Anchor Using Filters Using Filters
The main difference between Interactive Filters and traditional Input Controls is that you are able to click on items in the report to add filters instead of opening the Input Controls toolbar. Interactive Filters are powerful and can be used in different manners. Each report will use Interactive Filters differently.
Interactive filters are not available when Drill is enabled. The Interactive Icon will not appear on elements with interactivity available when drill is enabled.
Expand | ||||||
---|---|---|---|---|---|---|
| ||||||
|
Figure 6: Interactivity Examples. Click image to enlarge.
Clearing Interactive Filters Anchor Clearing Filters Clearing Filters
Since Interactive Filters create Input Controls, you proceed similarly to clearing individual Input Controls or all Input Controls.
- Individual Input Controls - Click the Clear Filters button or select All Values from the Input Controls values list.
- All Input Controls - Click the Reset button at the top of the Input Controls detail panel. This will either set the control to it's default state or clear it.
...