Usage and example of Tooltip

These procedures describe examples of how to create a report and configure the Tooltip web extension for individual cells.

Creating a report for the Tooltip web extension

  1. Create an Application Studio report with the Tooltip Sample name and insert the name into the C2 cell.
  2. Open the Accessories panel.
  3. Create a report variable named Data.
  4. In the properties of the variable, specify this information:
    Value (.Text)
    Specify this information: 
    <Table>
   <Row name="id1">
      <Property name="EntityCaption" value="Entity A" />
      <Property name="Value" value="94567892" />
   </Row>
   <Row name="id2">
      <Property name="EntityCaption" value="Entity B Products" />
      <Property name="Value" value="4569878111" />
   </Row>
   <Row name="id3">
      <Property name="EntityCaption" value="Entity C International Consumer Products Manufacturing and Distribution Consolidated Financial Holding Entity" />
      <Property name="Value" value="1200045" />
   </Row>
   <Row name="id4">
      <Property name="EntityCaption" value="Entity D" />
      <Property name="Value" value="4654654654" />
   </Row>
</Table>
    .
    Default Value (.DefaultText)
    Specify this information: 
    <Table>
   <Row name="id1">
      <Property name="EntityCaption" value="Entity A" />
      <Property name="Value" value="94567892" />
   </Row>
   <Row name="id2">
      <Property name="EntityCaption" value="Entity B Products" />
      <Property name="Value" value="4569878111" />
   </Row>
   <Row name="id3">
      <Property name="EntityCaption" value="Entity C International Consumer Products Manufacturing and Distribution Consolidated Financial Holding Entity" />
      <Property name="Value" value="1200045" />
   </Row>
   <Row name="id4">
      <Property name="EntityCaption" value="Entity D" />
      <Property name="Value" value="4654654654" />
   </Row>
</Table>
    .
  5. Create a formula list with an auto-generated name.
  6. Drag the formula list to the B5:D5 cell range.
  7. In the Report Objects folder, right-click Hyperblock1 and select Edit.
  8. In the List Designer panel, click Add and select the Data report variable.
  9. Click OK.
  10. In the Caption field, select EntityCaption and click Apply changes to the list.
  11. Right-click the hyperblock and select Format Hyperblock.
  12. In the Format Hyperblock dialog box, specify this information:
    Value
    Specify ="Unique Name".
    Display Value
    Specify ="Caption".
    Position
    Specify B5.
  13. Click OK.
  14. Click column B and select Columns.
  15. Select the Formula checkbox and specify =FALSE.
  16. Click OK.
  17. Select the C4 cell and specify Entity.
  18. Select the D4 cell and specify Revenue.
  19. Select the C5 cell and specify this formula: =IF(LEN(TEXT(B5,"~"))>20,LEFT(TEXT(B5,"~"),20)&"...",TEXT(B5,"~")).
    With this formula, the text in the B5 cell is truncated if the text exceeds 20 characters, and an ellipsis is added.
  20. Select the D5 cell and specify this formula: =VALUE(GETPROPERTY(ReportVariables.Data.Text,B5,"Value")).

Configuring the Tooltip web extension

  1. Insert the Tooltip web extension into the C5 cell.
  2. In the Tooltip field in the Format Web Extension dialog box, specify this formula: =IF(LEN(TEXT(B5,"~"))>20,TEXT(B5,"~"),"").
    With this formula, if the text in the B5 cell exceeds 20 characters, it is displayed as a tooltip. Otherwise, no tooltip is displayed.
  3. Click OK.
  4. Save the report.
    You can view the report in a web browser.