Once you have selected items to examine in a report, crosstab, or chart, Easy Reporter offers you many options for formatting the report. These include:
• Selecting a Presentation Style
• Selecting a Predefined or Custom Format
• Selecting Page Break Options
• Adding a Title and Description
Presentation styles vary depending upon whether you are creating a report, crosstab, or chart. They are explained in the following sections.
When creating a report, you need to choose a presentation style.
To choose a report presentation style, use one of the following:
• Select a presentation style from the drop-down list above the Selected Items: field.
• Choose a report style from the Report menu then select a style from the dialog box.
The presentation styles are described in the following table.
|
Table 74: Report Presentation Style Descriptions |
|
Style |
Description |
|
Standard |
Displays the data row by row in a simple table. The table includes column breaks and summary functions. For examples of this style, see Default Reports on page 172. |
|
Drill Down |
Presents the data as a series of linked pages, arranged according to break levels of the report. The first page shows the top level of the report, which displays the summary functions and the links to the next level of detail. You can move down through the hierarchy of detail information by clicking the linked values on each page. To go back to the next highest level of summary, click the link in the column heading. Easy Reporter allows up to 29 levels in a drill-down report. Note: To create a drill-down report, you must set break levels as described in Setting Break Levels on page 374. For examples of this style, see Drill-Down Report on page 175. |
|
Master Detail I |
Similar to a drill-down report, except that all the detail levels appear on one page. All the break columns given are listed horizontally. For examples of this style, see Master-Detail Reports on page 178. |
|
Master Detail II |
Similar to a drill-down report, except that all the detail levels are displayed on one page. All the break columns listed are listed vertically. For examples of this style, see Master-Detail Reports on page 178. |
|
Form |
Displays each row of the results vertically, in its own HTML table. For examples of this style, see Form Report on page 176. |
|
Label |
Displays results in three HTML tables across the page horizontally. For examples of this style, see Label Report on page 177. |
|
Break Form |
Displays results as in a break report, except without column headings. For examples of this style, see Break Form Report on page 178. |
|
Drill Chart |
Similar to a drill-down report, except the results are displayed in a chart rather than a table. Detailed information is available by clicking the data elements in the chart. Clicking the bottom level (finest detailed chart level) will drill-down into a report. For examples of this style, see Drill-Chart Report on page 179. |
The presentation styles for crosstabs are Standard, Drill Down, Master Detail I, and Master Detail II, as described in Presentation Styles for Reports on page 370.
When creating a chart, click the Presentation Style button. The button icon displays the currently selected presentation style. Click the button to open a Presentation Style menu bar, as shown below. The buttons are described in Table 75.
|
|
Figure 231: Presentation Style Menu Bar |
|
No. |
Presentation Style Button |
Description |
|
1 |
2D Chart |
Displays your data in a two-dimensional chart. Items you wish to measure are placed along the horizontal axis and measures (such as specific numeric values) are plotted along the vertical axis. |
|
2 |
3D Chart |
Displays your data in a three-dimensional chart. The first item you place along the horizontal axis is plotted on the horizontal (x-) axis; the second is plotted on the z-axis. Measures are plotted along the vertical (y-) axis. |
|
3 |
Pivot Table |
Displays your data in a simple pivot table format. |
|
4 |
2D Chart + Pivot Table |
Displays your data in both a 2D chart and pivot table. |
If you have selected the 2D, 3D or 2D Chart + Pivot Table options, you can select the chart type from the Chart Type menu bar.
Click the Chart Type button to display the Chart Type menu bar, as shown below. The icons on the chart type button display the currently selected chart type. The buttons are described in Table 76.
|
|
Figure 232: Chart Type Menu Bar |
Note:
Not all buttons are available for all presentation styles. Buttons appear grayed out when not available.
|
No. |
Chart Type |
Description |
|
1 |
Bar Chart |
The default chart type for most displays. Bar charts are commonly used for their simplicity, and easily highlight the relative values of different data points. For examples of this style, see 2D Bar Chart on page 197 and 3D Bar Chart on page 203. |
|
2 |
XY Chart |
Best suited for searching for patterns in the relationships among different variables. Each datapoint is represented as a single dot. A positive correlation (for example, rising overhead correlated with rising total costs) results in a concentration of points forming a line moving up and to the right. A negative correlation (for example, rising costs negatively correlated with rising profits) results in a concentration of points moving down to the left. Unrelated variables produce a randomly scattered pattern over the field. For examples of this style, see 2D Scatter Chart on page 195 and 3D Scatter Chart on page 201. |
|
3 |
Line Chart |
Good for showing progressions through time, and often used to maintain a record of expenses and forecast future trends. In addition, line charts are useful for determining relationships: a peak in marketing expenses one quarter may be followed by a peak in production costs the next, reflecting increased demand for your product. For examples of this style, see 2D Line Chart on page 196 and 3D Line Chart on page 202. |
|
4 |
Area Chart |
Essentially a line chart with the area underneath the line shaded. This has the effect of emphasizing the amount of change in a value over the rate of change in the value. Also, an area chart may stack the values of your variables on top of one another, resulting in an emphasis on the largest sum at any given time rather than the peaks and valleys of individual data columns. For examples of this style, see 2D Area Chart on page 197 and 3D Area Chart on page 201. |
|
5 |
Pie Chart |
Shows the relationship between each item and the whole. For example, you may show what percentage of your annual expenditures go to marketing, payroll, and so forth. For examples of this style, see 2D Pie Chart on page 196 and 3D Pie Chart on page 202. |
|
6 |
Stack Chart |
Stacks each category of data on top of other categories, so that the topmost level for a division represents the total for that division. They are often used for comparing the budgets of different departments within each division. For examples of this style, see 2D Stacked Bar Chart on page 198 and 3D Stacked Bar Chart on page 204. |
|
7 |
Box Chart |
Similar to a bar chart, except that values are arranged along a baseline value, shown as the X-axis. In effect, the X-axis is moved up the chart. A box chart is primarily used for showing positive and negative values, such as the degree of profit/loss in a given year. For examples of this style, see 2D Box Chart on page 198 and 3D Box Chart on page 204. |
|
8 |
Grid Chart |
Shows each data element in its own cell. Use this chart when you want to emphasize before-and-after results, or sharply divide negative from positive data values. Note: This chart type is valid for 2D charts only. For examples of this style, see 2D Grid Chart on page 199. |
|
9 |
Contour Chart |
Filled-in three-dimensional representations of data, represented as x-, y-, and z-coordinates. Contour charts are particularly good for portraying topographic data. Note: This chart type is valid for 3D charts only. For examples of this style, see 3D Contour Chart on page 203. |
|
10 |
Combo Chart |
A combo chart lets you select a different display type for each measure. For example, you may display salaries in a bar chart format, length of time worked in a line chart format, and so forth. All are displayed together. Note: This chart type may contain multiple axes, however it displays them in a 2D format. |
Creating breaks in a report improves its readability by eliminating the display of repeating values in columns and by sorting rows of similar data into groups. You can add summary functions to display subtotals for each group and grand totals for the entire report.
Note:
Break levels can only be defined for items placed in the columns of reports or along the vertical axis in crosstabs.
To add a break level:
• Right-click the item on which you would like to base the break in the Selected Items: field.
• Select Break from the pop-up menu so that it is checked.
• The top right corner of the item label is cut to indicate the break level.
In the following example, a break has been placed in a standard report on the item node.
|
|
Figure 233: Example Easy Reporter Window Showing a Break Level |
Easy Reporter supports multiple levels of report breaks.
For examples of a break report, see Default Report with Break Levels on page 173 and Break Form Report on page 178. These sections refer to the selection of breaks in the Report Designer window, however, the example reports are identical to the reports generated by Easy Reporter.
To delete a break level:
• Right-click the item on which you placed the break in the Selected Items: field.
• Select Break from the pop up menu so that it is not checked.
To add a summary function to a break level:
1. Right-click the summary function in the Selected Items: field and select Summary from the pop-up menu.
2. The Select Summary Function window is displayed, as shown below.
|
|
Figure 234: Select Summary Function Window |
3. Select the radio button for the appropriate summary function.
4. Select the appropriate break level from the Apply to break levels list.
5. If you wish to create a grand total for the report, select Add to report level.
6. Click OK.
Easy Reporter allows you to select from a number of predefined formats for reports and crosstabs. It also allows you to create your own custom format.
To select a predefined report format:
1. Select the menu option FormatÆTable.
2. The Table Format window is displayed, as shown below.
|
|
Figure 235: Table Format Window |
3. Select a format from the Formats list.
4. Click OK to apply your changes.
You can see the format only in Print Preview mode, as described in Previewing Before Printing on page 391.
To create a custom report format:
1. Select the menu option FormatÆTable. The Table Format window is displayed.
2. In the Formats list, select the format Customized.
3. Click the Customize button.
4. The Customize window is displayed, as shown below.
|
|
Figure 236: Customize Window |
5. The options in the Customize window are described in the following table.
|
Table 77: Customize Window Options |
|
Option |
Description |
|
Header Color |
Choose a color for the heading row from the drop-down list. To choose a custom color, click More. |
|
Row Color |
Choose a color for the odd numbered rows from the drop-down list. To choose a custom color, click More. |
|
Alternate Row Color |
Choose a color for the even numbered rows from the drop-down list. To choose a custom color, click More. |
|
Show Table Border |
If checked, a black border surrounds the entire table and separates each table cell. If not checked, no border appears. |
6. Click OK.
7. On the Table Format window, click OK to apply your changes.
You can see the format only in Print Preview mode, as described in Previewing Before Printing on page 391.
Easy Reporter allows you control various layout options for your report, crosstab, or chart. The layout options control what background template to use (if any), and whether or not to display a date or description on the report. Layout options are independent of whether you are creating a report, crosstab, or chart.
To select layout options:
1. Select the menu option FormatÆLayout.
2. The Layout window is displayed, as shown below.
|
|
Figure 237: Layout Window |
3. The options are described in the following table.
|
Table 78: Layout Options |
|
Option |
Description |
|
Template |
If you select a template from this list, it is used as the background for the report. The template might include company logos and header and footer information. Templates can be used to give your reports a standard look. |
|
Date |
If checked, Easy Reporter displays the date and time you ran the report at the top of the report page. |
|
Description |
Displays the report description on the report when selected. See Adding a Title and Description on page 384, |
|
Page number |
If selected, Easy Reporter displays the page number on each page. |
|
Fit report to window |
If selected, Easy Reporter causes the report to be resized when you resize the browser window. |
|
Measure/axis headings |
If selected, Easy Reporter displays measure and axis labels on crosstabs. |
|
Title font color |
Selects a color for the report's title text. When you click the drop-down list, a color window is displayed. Select a color from the dialog, or click More to choose from even more colors. |
|
Master color |
Selects a background color for break levels on Master Detail reports. When you click the drop-down list, a color window is displayed. Select a color from the window, or click More to choose from even more colors. |
4. Click OK.
There are two types of miscellaneous report options: those that apply to reports and crosstabs, and those that apply only to charts.
The following options apply to reports and crosstabs.
To edit your report options:
1. Select the menu option ReportÆReport Options.
2. The Report Options window is displayed, as shown below.
|
|
Figure 238: Report Options Window |
3. The options are described in the following table.
|
Table 79: Report Options |
|
Option |
Description |
|
Unique value rows |
If selected, Easy Reporter hides rows of data that are exact duplicates of other rows. If you would like all report rows to be displayed whether or not they are duplicates, make sure this checkbox is deselected. |
|
Zero value rows |
If selected, Easy Reporter displays all rows of data, even if some are blank. If you would like to prevent blank rows from being displayed, make sure this checkbox is deselected. |
|
Null values as zeroes |
If selected, Easy Reporter fills in blank data fields with zeroes. |
|
Maximum number of rows to be fetched |
Lets you specify how many rows of data appear in the detailed reports when running a Drill Down or Master Detail style report. |
|
Output Format |
Lets you specify the format in which the report are saved. For descriptions of the different output formats, see Report Style Tab on page 250. |
|
Insert hyperlink |
If you are generating a comma-separated values (CSV) report or a Microsoft Excel report, you can place a hyperlink to them on the HTML report. To do that, select the option that is compatible with your selected output format. |
4. Click OK.
The following options apply only to charts.
To edit your chart options:
1. Select the menu option ReportÆChart Options.
2. The Chart Options window is displayed, as shown below.
|
|
Figure 239: Chart Options Window |
3. The options are described in the following table.
|
Table 80: Chart Options |
|
Option |
Description |
|
PM File |
Specifies a template that affects the legend position, menu color, text font and size, the colors for the chart background, item colors, and pie chart colors. Note: Only an administrator may create new PM files or alter existing files. |
|
Chart Descriptor |
Allows you to select the appearance (either 2D or 3D) of the chart applet itself. A descriptor can be created by modifying the appearance of the chart while viewing the chart in runtime mode. |
|
Measure Format |
Controls how the numbers are displayed in the measure. The options include: whole numbers only, decimal values, dollar values. |
|
Number of Tics |
Controls how many tics are displayed for each chart label. The default value of 1 means that each tic has a label. Setting the value to 5 means the chart is displayed with 1 label for every 5 tic marks on the horizontal axis of the chart. |
|
Maximum number of rows |
Limits the amount of data that is returned from the database and sent to the chart. This can speed the process of designing a chart by reducing the time required to generate sample charts. This can also prevent a chart from becoming overcrowded with an excessive number of data points. Note: The maximum number of rows you can display may have been set by your administrator. If your administrator enforces such a limit, you may not override it. |
|
Applet Width, Height |
Controls the chart applet's dimensions, in pixels. |
|
Show Title Inside the Applet |
When selected, the report title is displayed inside the applet window which displays the chart. |
|
Min / Max scale value |
Sets the maximum and minimum values that the chart can be scaled to. |
4. Click OK.
Page break options allow you to specify whether you would like to display long reports as multiple tables on a single HTML page or as a single, large table on multiple HTML pages. These options apply to reports and crosstabs.
To select page break options:
1. Select the menu option ReportÆPage Break Options.
2. The Page Break Options window is displayed, as shown below.
|
|
Figure 240: Page Break Options Window |
3. The options are described in the following table.
|
Table 81: Page Break Options |
|
Option |
Description |
|
Multiple tables |
Specifies whether you want to be able to see all the rows for the report on a single page or if you want to print out the entire report at once. Because some Web browsers limit how much data a single table can display, you may want to limit the size of the tables on that page using the rows per table option. Do not set rows per table above 1000 unless you are sure your Web browser supports very large tables. |
|
Multiple HTML pages |
When selected, the rows per page field controls how many rows of data appear on each page. Setting the number higher increases the size of each page. Setting it lower increases the total number of pages. This is the default setting for displaying your report. |
4. Click OK.
Easy Reporter allows you to add a title or description to your report, crosstab, or chart. Both are optional. The title and description you enter here is placed on the report itself, as described in Selecting Layout Options on page 378.
To add a title and a description:
1. Select the menu option FileÆProperties.
2. The File Properties window is displayed, as shown below.
|
|
Figure 241: File Properties Window |
3. Enter a title and a description as required.
4. Click OK.
The File Properties window also displays some additional information that is set by your administrator. This is described in the following table.
|
Table 82: File Properties Information |
|
Option |
Description |
|
Allow cartesian |
An SQL report may sometimes contain a Cartesian product in the query. This is when the query draws on two different tables without joining them together, with the result that the number of lines of output is the product of the number of lines returned from each table. If you run a report that returns a Cartesian product, the report may fail and you may be shown an error message. If you are allowed to run Cartesian queries, Allow cartesian is set to true. If you need to change this setting, contact your administrator. Note: If Allow cartesian is set to false, you cannot run a report or save a snapshot that contains a cartesian query. You can still save the report definition. |
|
Maximum number of rows |
This setting displays the number of rows a report can return. If there is no limit, Maximum number of rows is set to Unlimited. If you need to change this setting, contact your administrator. |