You can set the size of columns / rows on pages of the Table type. To do this, select “Set Size of Columns / Rows …” from the “Table” main menu: This submenu allows the user to specify the same width for all columns and the same height for all rows of the table:

For any report you can create a description using any text, used hierarchies and RTF formatting. Let us look at the example: In the “Table” menu select the “Report Page Description”: In the left part there is a list of hierarchies which are used on the report page. Using the mouse drag some hierarchies into […]

In order to explain what is “Visual Totals” let us build the following report. On the rows we will place the “Product Categories” hierarchy with the following selection: On the columns let us place the years from the “Date.Calendar” hierarchy. Inside the table – the “Reseller Order Quantity” measure. You will get the following report:

You can add summary rows and columns to the report. These rows and columns will show the SUM of the elements on the topmost visible level in the report. In the “Table” menu select the items “Show Summary Columns” and/or “Show Summary Rows”: Then you will get the following report: As you may see, in […]

In the sample report (above) you can see that the row with “Clothing” there is a total of all kinds of clothing, but NOT just 2 selected elements (“Caps” and “Jerseys”). In order to see the totals for only visible elements, you have to select “Show Visual Totals” item in the “Table” menu: If you […]

In the context menu there is an operation “Drill by”. Let us look at the example. Assume you have a report of the following structure: Let us do the “Drill by” operation in order to look the sum of sales for a specific product (for example, for “Road Bikes”) by all countries. Select menu items […]

Each page has an important option – «Automatically change data when the structure is changed». If this option is on, after each change of the page structure the new data will be displayed. If this option is off, you can change the structure of the page first (data will not be automatically refreshed), and then […]

Quick data formatting is available on the toolbar: This functionality allows you to quickly format the data you have selected:

A chart is a part of a report. It may be not displayed, displayed alone or with a table. The view mode of a chart can be changed on the toolbar or in the “Table / View Mode” menu: In the lower left corner you may see the chart parameters: Layout: influences where the chart […]

If you press the button “Settings” in the bottom of the page, you will see the following form: