Sample crosstab in DataSet format

This sample illustrates the main parts of a DataSet document for a crosstab report.

Here is an example based on the sample report used in Sample crosstab in LDX format

This report is run using a filter to return just the crosstab. The REST URL to run this report is shown here:

http://localhost/ibmcognos/bi/v1/disp/rds/reportData/path
/Public%20Folders/Samples/Models/GO%20Data%20Warehouse%20%28analysis%29
/Report%20Studio%20Report%20Samples/Returns%20by%20Order%20Method
?selection=Crosstab1&fmt=DataSet

The following sample XML is the crosstab report in LDX format. This sample XML does not include the entire layout data document. Removed sections are represented by ellipses (...).

<dataSet>
  <dataTable>
    <id>Crosstab1</id>
    <row>
      <Product__line>Camping Equipment</Product__line>
      <Defective__product>36046</Defective__product>
      <Incomplete__product>57043</Incomplete__product>
      <Wrong__product__shipped>52199</Wrong__product__shipped>
      <Unsatisfactory__product>61549</Unsatisfactory__product>
      <e2004>33817</e2004>
      <e2005>50769</e2005>
      <e2006>57013</e2006>
      <e2007>65238</e2007>
    </row>
    ...
    <row>
      <Product__line>Golf Equipment</Product__line>
      <Defective__product>6221</Defective__product>
      <Incomplete__product>5817</Incomplete__product>
      <Wrong__product__shipped>13105</Wrong__product__shipped>
      <Unsatisfactory__product>10068</Unsatisfactory__product>
      <e2004>6287</e2004>
      <e2005>6731</e2005>
      <e2006>14047</e2006>
      <e2007>8146</e2007>
    </row>
  </dataTable>
</dataSet>

As with the grouped list example, element names in the row elements are derived from the column title names in the original report.