Create Dashboard Report table example

To generate a Dashboard report that displays a table for each of its charts, follow these steps:

  1. Populate two Table datasets named Table1 and Table2 with the data to be used for the Dashboard report.
  2. Use the Create Dashboard Report action to generate a single Dashboard report that includes charts for the Table1 and Table2 datasets. Link the action’s Source1 and Source2 properties to the Table1 and Table2 datasets. The following example XML code may be used as the action’s Dashboard specification to create a report that includes two column charts and their corresponding tables. Note that in the second table, the header row is not displayed.

<REPORT>

<ROW>

<CELL Span="span2">

<OBJECT Param="Source1">

<GRAPHIC>

<TYPE>Column</TYPE>

<SHOW_VALUE_LABELS>false</SHOW_VALUE_LABELS>

</GRAPHIC>

</OBJECT>

</CELL>

<CELL Span="span2">

<OBJECT Param="Source2">

<GRAPHIC>

<TYPE>Column</TYPE>

<SHOW_VALUE_LABELS>false</SHOW_VALUE_LABELS>

</GRAPHIC>

</OBJECT>

</CELL>

</ROW>

</REPORT>

  1. Run the Dashboard report and verify that two charts are displayed.
  2. Update the Dashboard specification to include a second <OBJECT> section for each Source parameter. Each <OBJECT> section should include a <TABLE> section which specifies the properties for the charts’ tables.

<REPORT>

<ROW>

<CELL Span="span2">

<OBJECT Param="Source1">

<GRAPHIC>

<TYPE>Column</TYPE>

<SHOW_VALUE_LABELS>false</SHOW_VALUE_LABELS>

</GRAPHIC>

</OBJECT>

<OBJECT Param="Source1">

<TABLE>

<WIDTH>400</WIDTH>

<HEIGHT>150</HEIGHT>

<TITLE>First Table</TITLE>

<BACKGROUND_COLOR>Cornsilk</BACKGROUND_COLOR>

</TABLE>

</OBJECT>

</CELL>

<CELL Span="span2">

<OBJECT Param="Source2">

<GRAPHIC>

<TYPE>Column</TYPE>

<SHOW_VALUE_LABELS>false</SHOW_VALUE_LABELS>

</GRAPHIC>

</OBJECT>

<OBJECT Param="Source2">

<TABLE>

<WIDTH>400</WIDTH>

<HEIGHT>150</HEIGHT>

<TITLE>Second Table</TITLE>

<BACKGROUND_COLOR>Cornsilk</BACKGROUND_COLOR>

<SHOW_HEADER>false</SHOW_HEADER>

</TABLE>

</OBJECT>

</CELL>

</ROW>

</REPORT>

  1. Run the workflow and examine the generated Dashboard report.

Related topics

Create Dashboard Report actions