When you create a new report template by selecting the menu option FileÆNew, the Select Report Template window is displayed, as shown below:
|
This window provides a number of pre-defined report templates which you can choose to start with. The templates usually define how many charts, tables or page areas are on the page, and how they are positioned. For detail information on Page Area, see Working with Page Areas on page 469. To select the desired template, select it and click OK. You can also select the blank template to start creating a template that meets your specific needs. Once a template is selected, its name is displayed in the field at the lower right corner of the window. When the OK button is clicked, the Freeform Report Designer window is displayed.
The predefined templates are described in the table below.
|
Table 89: Predefined Freeform Templates |
|
Template |
Template Name |
Description |
|
Two Areas |
These templates have two, three, or four page areas placed on the page with mode of Container. 1. The pre-set page areas are all at the Container mode, this ensures that the content within each area does not overlap with other areas, and positions and sizes of the areas do not change with their contents unless you make the adjustment in the Master Layout view. 2. To expand to the next page, choose the menu option InsertÆPage Break. 3. To add elements into the areas, see Inserting Text, Inserting Images, Inserting Charts,Inserting Tables (Text and Reports), or Inserting Forms (Text and Reports) for detail information. 4. Do not change the area mode to Non-container as these predefined areas work well only at the Container mode.
To ease the use of these templates, a brief demonstration is provided in section Demo 1: Using the Predefined Two-Areas Template on page 423. This demo uses the Two-Areas template as example to depict steps involved with adding elements into areas. The same information applies to all the other templates in this category.
|
|
Three Areas |
|
|
Four Areas |
|
|
Two charts and one table |
These templates have areas predefined on the page and have either charts or tables added into the areas. 1. The preset areas are all at the Container mode, with the same behaviors as described above. 2. To expand to the next page, choose the menu option InsertÆPage Break. 3. To assign datasource to a table or a chart, double click it or right click it and select Properties to open its properties window. Refer to Inserting Charts or Inserting Tables (Text and Reports) for more information. 4. If necessary, set a drill-across table for a table element such that clicking the table data opens another table it points to. 5. Do not change the area mode to Non-container as these predefined areas work well only at the Container mode.
To ease the use of these templates, a brief demonstration is provided in section Demo 2: Using the Predefined One-Chart One-Table Template on page 431. This demo uses the One-Chart and One-Table template as example to describe procedures involved with defining data source for charts and tables and get the chart and table fit areas. The same information applies to all the other templates in this category. |
|
Three charts and one table |
|
|
Four charts |
|
|
One chart and one table |
|
|
One table |
These two templates have either a table or a chart element added on the page, with no areas pre-defined. 1. The page has no areas placed into it and the default area mode is Non-container. 2. To expand to the next page, simply press the Enter key on your keyboard. 3. To assign datasource to a table or chart, double click the element to open its properties window. 4. To add other elements onto the page or add areas, see sections Inserting Text, Inserting Images,Inserting Charts, Inserting Tables (Text and Reports), or Inserting Forms (Text and Reports) for detail information.
To ease the use of these templates, a brief demonstration is provided in section Demo 3: Using the Predefined One-Chart Template on page 433. This demo uses the One-Chart template as example to describe procedures involved with defining data source for charts. The same information applies to the other template in this category. |
|
One chart |
|
|
Blank template |
No elements are added on the page. Refer to the following sections for information on creating a freeform template. |
When the Two Areas template is selected in the New Report window, as shown in Figure 257, the Freeform Report Designer window is opened, as shown in the figure below:
|
|
Figure 258: Two Areas Template |
The two pre-set areas are both at Container mode. This section is going to describe how to add a chart and a table into the areas as well as how to adjust the size of the added chart and table.
To add a table into the area on the left and designate a datasource for the table, follow the steps below:
1. Click on the left area to select it.
2. Click the Insert Table button in the toolbar, as shown below.
|
|
Figure 259: Insert Table Button |
3. The table size popup window is displayed, as shown below.
|
|
Figure 260: Table Size Popup Window |
Use the cursor to select any number of rows and columns and click the mouse. It does not matter how many cells you select as the actual size of the table is determined by the datasource to be selected in the next step.
4. A placeholder table appears on the template, as shown below:
|
|
Figure 261: A Placeholder Table Added into Area |
To select a datasource for the table:
1. Double click the placeholder table (or right-click it and select Properties) to open its Properties window, as shown below:
|
|
Figure 262: Table Properties Window Table Tab |
2. Go to the Data Source tab.
3. Click Select and this opens the Select Data Source dialog.
4. Select the desired table (for example, ReportQ1.rpt) and click Open on the Select Data Source dialog.
5. The datasource name (selected table name) appears in the Data Source field on the Data Source tab.
6. Click OK to confirm the datasource selection and exit the Properties window.
Once a datasource is selected for the table, you can preview the table by clicking the Preview button to see how the actual table fits with the area. As the area mode is Container, this means that when the table content overflows the area, the table data will be partially displayed in the area and any leftover contents are discarded. Therefore, you may want to adjust the table to make it fit the area or resize the area to fit the content.
• Adjusting the Layout of the Table
To adjust the layout of the table, double click the table to open its Properties window. Go to the Table tab. Select Fit Page or other four radio buttons to resize the table depending on your requirement. The options are explained in the table below:
|
Table 90: Layout Section Options--Partial |
|
Options |
Description |
|
Fit Page |
This radio button sets the table to the width of the page or page area. It also sets each column to a width proportional to the widest piece of data in the column. |
|
Fit Content and Page |
This radio button changes the width of each column to the same width as the widest piece of data in the column. However the last column is expended to the right edge of the page. |
|
Fit Content (Wrap One Table Region Per Page) |
This radio button changes the width of each column to the same width as the widest piece of data in the column. If the total width of the table exceeds the page width or area width, columns are cut from the right side and pasted on the next page. |
|
Fit Content |
This radio button changes the width of each column to the same width as the widest piece of data in the column. If the total width of the table exceeds the page width or area width, columns are cut from the right side and pasted below the table. |
|
Equal Width |
This radio button sets the table to the width of the page or page area. It also sets each column to the same width within the table. |
• Adjusting the Size of an Area
If you need to adjust the size of the area, select the menu option ViewÆMaster Layout. This view displays only the areas added on the page, and no content is displayed. Click the left area and a resize box is placed around its border. Drag the resize handles on the resize box until the area is dragged to the desired size. Preview the table and make further adjustments to the size if required.
Once the area is resized, be sure to return to the Page Layout view using the View menu in order to continue other operations.
To add a chart into the area on the right and designate a datasource for it, follow the steps in the following sections.
To insert a chart into the right area,
1. Click the right area first then click the Insert Chart button, as shown below:
|
|
Figure 263: Insert Chart Button |
2. The Chart Properties window immediately opens, with the Chart tab selected by default, as shown below:
|
|
Figure 264: Chart Properties Window Chart Tab |
3. Click Select and this opens the Select Data Source dialog.
4. Select the desired chart (for example, ChartQ1.cht) and click Open on the Select Data Source dialog.
5. The datasource name (selected chart name) appears in the Data Source field.
6. Click OK to confirm the datasource selection and exit the Properties window.
7. A placeholder chart appears within the area, as shown below:
|
|
Figure 265: Chart Properties Window Chart Tab |
Once the chart appears on the template within the area, you can preview the chart by clicking the Preview button to see how the actual chart fits with the area. As the area mode is Container, this means that when the chart itself is larger than the area, the chart will be partially displayed in the area and any leftover proportion is discarded. Therefore, you may want to adjust the chart to fit the area or resize the area to fit the chart.
• Adjusting the Size of the Chart
Click the placeholder chart and a resize box is placed around its border. Drag the resize handles on the resize box until the chart is dragged to the desired size. Preview the chart and further adjust it to ensure it properly fits the area.
• Adjusting the Size of an Area
If you need to adjust the size of the area, select the menu option ViewÆMaster Layout. This view displays only the areas added on the page, and no content is displayed. Click the area and a resize box is placed around its border. Drag the resize handles on the resize box until the area is dragged to the desired size. Preview the chart and further adjustment on the area size is possible.
Once the area is resized, you should return to the Page Layout view using the View menu in order to continue other operations.
When the 1 Chart 1 Table template is selected in the New Report window, as shown in Figure 257, the Freeform Report Designer window is opened, as shown in the figure below:
|
|
Figure 266: One Chart One Table Template |
As shown in the above window, this template contains one chart and one table. If you switch the view to Master Layout, you will also find that there is one area defined behind each table and chart, and the areas are both set to Container mode.
Compared with the Two-Areas template discussed in Demo 1, this template has already had a chart and a table elements added into the areas, and thus you do not need to add any of such elements, but you will still need to select datasources for the elements and if necessary, adjust the sizes of the elements to make them fit with their own area. These operations are the same as with the Two Areas template. Refer to sections Adding and Selecting Datasource for the Chart on page 428, Getting the Chart Fitting the Area on page 429, Selecting Datasource for the Table on page 426, and Getting the Table Fitting the Area on page 427 for relevant information.
Note that since the chart is already placed in the area, you can double click it to open its Properties window. Follow the instructions in Adding and Selecting Datasource for the Chart on page 428 to select a datasource for it.
When the 1 Chart template is selected in the New Report window, as shown in Figure 257, the Freeform Report Designer window is opened, as shown in the figure below:
|
|
Figure 267: One Chart Template |
A chart is predefined on the template, and it is placed on the page directly, not in an area. This is the biggest difference between this template and the two discussed in Demo 1 and Demo 2.
Double click the placeholder chart to open its Properties window, and select a data source for it on the Chart tab. Refer to Adding and Selecting Datasource for the Chart on page 428 for relevant information. To resize the chart, click it and drag the resize handles until it is dragged to the desired size.
To add other elements onto the page, refer to the relevant sections in this chapter.