Usage and example

To configure the toolbar web extension, you must specify these parameters:

  • Theme: Specifies the color theme. Options are Vibrant and Subtle.
  • Mode: Specifies the style. Options are Light, Dark, and High Contrast.
  • List of Items: Defines the unique names of the toolbar elements as a cell range.
  • Item Data: Defines the properties of the toolbar elements as a cell range of a data table or as a cell reference to an XML definition.
  • Margin: Specifies whether the toolbar has margin and, if yes, the width of the left and right margins, in pixels.
  • Background: Specifies if the toolbar has a background color. Valid values are FALSE for transparent background and TRUE for color.
  • Toolbar Title: Specifies the title of the toolbar.

To create a sample of the toolbar web extension:

  1. Create the data table for the toolbar. See Data table.
  2. Insert the web extension in cells B1:J3. Increase the height of the rows as necessary.
  3. Create a report variable called toolbar_settings, toolbar_filter, and toolbar_suppression.
  4. For each item in the Id column, create a Set Parameter action, with TRUE as its condition and Web Extension as its mode. Select the Refresh in web optional input, with a value of Whole report.
  5. For the Id9 action in B14, add a parameter with these values:
    • Name: Select the toolbar_settings report variable.
    • Property: Select Value (.Text).
    • Value: Specify this formula:
      =IF(GETPROPERTY(ReportVariables.toolbar_settings.Text,"id9","selected")="TRUE",SETPROPERTY(ReportVariables.toolbar_settings.Text,"id9","selected","FALSE"),SETPROPERTY(ReportVariables.toolbar_settings.Text,"id9","selected","TRUE"))
  6. For the Id11 action in B16, add a parameter with these values:
    • Name: Select the toolbar_filter report variable.
    • Property: Select Value (.Text).
    • Value: Specify this formula:
      =IF(ReportVariables.toolbar_filter.Text="TRUE", "FALSE", "TRUE")
  7. For the Id13 action in B18, add a parameter with these values:
    • Name: Select the toolbar_suppression report variable.
    • Property: Select Value (.Text).
    • Value: Specify this formula: 
      =IF(ReportVariables.toolbar_suppression.Text="TRUE", "FALSE", "TRUE")
    • Value: Specify =FALSE.
  8. For the Id14 action in B19, add a parameter with these values:
    • Name: Select the toolbar_filter report variable.
    • Property: Select Value (.Text).
    • Value: Specify =FALSE.
  9. For the Id15 action in B20, add a parameter with these values:
    • Name: Select the toolbar_suppression report variable.
    • Property: Select Value (.Text).
    • Value: Specify =FALSE.
  10. For each image in the MediaName column, specify the unique name of the shared image to display in the toolbar.
  11. Double-click the web extension to open the Format Web Extension dialog box and specify these values.
    Theme
    Specify ="Vibrant".
    Mode
    Specify ="Light".
    List of Items
    Specify =B6:B20.
    Item Data
    Specify =B5:J20
    Margin
    Specify ="".
    Background
    Specify =FALSE.
    Toobar Title
    Specify ="Sample Toolbar"
  12. Click OK and view the report in a web browser.