Create Dashboard Report table example

To generate a Dashboard report that displays a table for each of its charts, carry out the following 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 Source 2 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.

Create Dashboard Report actions