• on one or more data files. In this case, an embedded query is used. This query is created via the wizard for creating a "Crosstab" report. For more details, see Creating a Crosstab report based on a query.

1. Select "Description" in the context menu of the report. The description window of the report is displayed.
2. Go to the "Data" tab.
3. Click the "Edit" button.

1. Click in the quick access buttons:
2. The window for creating a new element is displayed: click "Report" then "Report".
3. The report creation wizard starts. Select "Crosstab".
4. The wizard then asks you to select the report source: choose "From one or more files"..

• the item corresponding to the captions of the columns.
  Remark: If this field is of type "Date", the wizard suggests:
  • keep the day, the month or the year only for these dates.
  • define the period to take into account (start date and end date).
• the item corresponding to the captions of the rows.
  Remark: If this field is of type "Date", the wizard suggests:
  • keep the day, the month or the year only for these dates.
  • define the period to take into account (start date and end date).
• the information that will be displayed in the table cells. This information can correspond to:
  • either the number of records corresponding to the intersection of rows and columns.
    For example: the number of orders placed per year and per customer. The customer named "Smith" has placed 2 orders in 2000 and 3 orders in 2001.
  • the sum, the average, the maximum or the minimum of an item.
    For example: the number of products ordered per product and per year. In 2000, 279 sofas were ordered.
  • an item.
    For example: the score awarded by each referee to an ice skater. At the 2000 European Championships, the Italian judge awarded 5.2 to skater "A".
• the calculation of totals for the table rows and columns (if necessary).
• the format of the page on which the report will be printed. The report is printed in A4 format by default.
• the skin template of the report (if necessary).
• the name and title of the report. This name (".WDE". file corresponding to the report) will be used to identify the report in your programs.

1. Click in the quick access buttons.
2. The window for creating a new element is displayed: click "Report" then "Report".
3. The report creation wizard starts.
4. In this wizard, specify:
   • the type of report to be created: "Crosstab".
   • the Pivot Table control used as data source.
   • the skin template of the report (if necessary).
   • the name and title of the report. This name (".WDE". file corresponding to the report) will be used to identify the report in your programs.

Pivot Table control (Report editor) features

• The data source of the report can be modified in the "Data" tab of the description window of report ("Report description" in the context menu of the report).
• The "General" tab of the Pivot Table control description window is used to specify:
  • the cell width calculation mode: the following options are available:
    • Use the width defined in editing: cells will be displayed with the same width as that defined in the report editor..
      Note: You can use the sizing handles to resize the data area in the Pivot Table control in the report..
    • Fill the page as wide as possible: if there's space left on the page, the cells will be enlarged to fill the empty space.
    • Avoid truncated cells: if there's space left on the page, cells may be enlarged to display all the data they contain.
  • dimensional sequence: the following options are available:
    • Like the field: the level of detail displayed in the report will be the same as that of the Pivot Table control used as the data source.
    • All unrolled: all data in the dynamic array will be displayed.
    • All rolled up: only the first level of detail in the Crosstab will be displayed.
• The "Style" tab in the TCD control description window is used to define the style of the control: the "Define style independently of printed TCD control" option is used to define a specific style for the control in the report.. If this option is checked, you have the ability to specify the style for the row headers and for the data.