By default when using the listing wizard in the e.Spreadsheet Designer, the resultant data range displays data expanding vertically on the sheet. What controls the expansion of the data on the sheet is the detail() report function. The listing wizard always places this on a row section, however the detail() function can be used on column sections to cause the data to expand horizontally across the page.

The vertical tab was created using the Listing Wizard and shows a typical grouped example where data expands down the sheet. The horizontal tab was created using the following steps:

1. Insert a data range (Report --> Create Data Range)
2. Select the column stub of the column you want to expand across the page. Right click and select Create Parent... Give the section a name ( I named mine Detail)
3. Enter detail() in the column function area for the section you just created.
4. Select the detail section handle (the stub with the name you entered in step 2), right click and select Create Parent... Give the section a name (I named mine Customer).
5. Select the detail section handle again. Right click and select Insert Column Before.
6. Select the section handle created in step 4. Right click and select Group... Select the field you want to group on.

This example was created using the e.Spreadsheet Designer version 10 SP1.