To build such kind of a report, we need to take the following steps:
1. Create a Free Format Template, which will combine Gauge, Table and Item Selector controls
2. Create a list of items to be included in the Item Selector
3. In Report Parameters for Gauge and Table controls set "External Item Selector" parameter to "Item Selector"
4. In Report Parameters for Item Selector set "Item Selector" parameter to the required list of items
5. Optionally, you can set "Default Item Selector" and "Label Format" parameters of Item Selector to the required values (see section Parameters below).
As a result, we will get the report, where Gauge and Table values are picked from the Item Selector list:
How to use a different control as an Item Selector?
Now let's consider an example, when we do not want to use Item Selector as a separate control. Instead, we would like to combine a Table, a Pie and a Bridge controls in the Free Format Template. Then we will make the Pie and the Bridge "listen" to the Table rows - i.e. once we click on a particular row (which for example represents Account member), the values in the Pie and in the Bridge will be displayed according to this account.
To build such kind of a report, we need to take the following steps:
1.Create a Free Format Template, which will combine Table, Pie and Bridge controls (in our example we use account list for the table rows, customer DescendantsExclusive list for the pie chart and product DescendantsExclusive list for the bridge)
2. In Report Parameters for the Pie set "Item Selector" parameter to "Table"
3. In Report Parameters for the Bridge set "Item Selector" parameter to "Table"
4. In Report Parameters for the Table set "Clickable Rows" parameters to "Yes"
As a result, we will get the report, where the pie and the bridge charts are changed according to the table rows:
Item Selector Parameters
Basic Control Parameters
Parameter | Mandatory | Description |
---|---|---|
1. Item Selector | Yes | A list of items that will be used as a Pick List in the selector |
2. Default Selected Item | No | Indicates an item, which will be selected upon opening the report |
Advanced Control Parameters
Parameter | Mandatory | Description |
---|---|---|
1. Label Format | No | Format, which should be applied to the items within the Item Selector |