Cross Table

1. Define an excel server template.

2. Select the data area of cross table, right click, choose "Multiple Field":

3.Click "Cross", set the value pattern:

Click "Next":

4.Click "Next":

5.Fill the field name, select data type, and click "Next":

 Merged cell can not be  defined Input Criteria.

6.Create data table, and click "Finish":

See also:

Data fetcher for Cross Table

Excel Server homepage