You can insert one or multiple tables on a report. You insert tables by dragging one of the following onto a blank area of the report:
• the objects, for which you want the table to display values – this is a fast way to build simple, vertical tables
or
Results View displays the results retrieved from the data source and how the report will print
Structure View displays the structure of the report, and the definition of the data, filters, sorts and calculations
Note: When you create a new document, Web Intelligence generates a default report with a vertical table that contains all the objects in the query. You can modify or remove this table. See ”Applying a different template to existing tables” on page 135 or ”Clearing cells and removing tables” on page 146.
For information on creating new documents, see “Template ook” on page Chapter. For information on inserting additional blank reports into a document, see ”” on page 353.
Creating a table by dragging objects onto a report To create a table by dragging objects onto a report:
1. Make sure you are in Report View.
When you work in Report View, the report tab(s) appear across the bottom of the Document pane. You can go to Report View by clicking the Edit Report button on the Web Intelligence toolbar.
The objects in the document appear in the Data tab.
If the Data tab is not visible, click the Show/Hide Manager button on the Report toolbar.
2. How you add objects to a report depends on whether the report is empty or not:
• If the report is empty, select either a single object or a class folder on the Data tab, and then drag and drop the object or class onto the report.
Selecting a class folder adds all the objects from the class onto the report in the new table.
Or
• If the report already contains tables or charts, press the Alt key, then with the Alt key pressed, drag an object onto an empty area of the report.
A new table header and body cell appears on the report. The table header displays the name of the object.
3. To add another object to the table, drag another object from the Data tab and place it to the left or right of the existing column header.
4. When the “Drop here to insert a cell” ToolTip appears, drop the object onto the left or right of the table header.
A second column appears before or after the first column. The new column header displays the name of the object.
5. To add more objects to the table, repeat step 3.
Web Intelligence displays the values in a vertical table.
You can quickly turn the vertical table to a different table format, such as a crosstab by using the Turn To feature. See ”Applying a different template to a table using the Turn To dialog box” on page 137.
Creating a table by selecting a template To create a table by selecting a template:
1. Make sure you are in Report View.
When you work in Report View, the report tab(s) appear across the bottom of the Document pane. You can go to Report View by clicking the Edit Report button on the Web Intelligence toolbar.
2. Click the report tab of the report where you want to insert a table.
To find out how to add a blank report to the document, see ”” on page 353.
3. Click View Structure.
Working in Structure View allows you to define and preview the new table without requesting the server to apply each of your modifications. You then apply all your modifications and display the results in the new table, by returning to Results View.
4. Click the Templates tab.
If the Templates tab is hidden, click the Show/Hide Manager button on the Report toolbar.
The available Templates appear.
5. Click the + sign next to Tables.
The table templates are listed.
6. Drag a template from the Template tab onto a blank area of the report.
The template appears on the report.
7. Click the Data tab.
The objects and variables that the document contains appear here. You can add any of these objects or variables to the table.
8. Drag an object or variable onto an empty header or body cell of the table.
9. When the ToolTip “Drop here to replace cell” appears, drop the object onto the table.
The empty cell is replaced by the object.
If you are working in Results View, the values of the objects display on the table.
If you are working in Structure View, the name of the object displays on the table.
10.To add more objects to the template, drag an object from the Data tab and drop it onto the template.
Make sure that the ToolTip “Drop here to replace a cell” appears, and then drop the object onto the template.
11.If appropriate, repeat step 10. to allocate more objects to the table columns, rows and body.
Once you have allocated objects to each part of the table template, you can add more objects to increase the size of the table. Each additional object inserts more columns or rows onto the table.
12.To add another object and create an additional table column or row, drag an object from the Data tab and drop it onto a row or column.
• If you drop the object onto the left of a column, you create a new column before the existing column.
• If you drop the object onto the right of a column, you create a new column after the existing column.
• If you drop the object onto the top edge of a row, you create a new row above the existing row.
• If you drop the object onto the bottom edge of a row, you create a new row below
Structure View
Results View
Make sure that the ToolTip “Drop here to insert a cell” appears before you drop the object.
The object appears in a new table cell.
13.If you are working in Structure View, click View Results to display the values in the new table.