fyiReporting Software, LLC
Create a table
There are multiple ways to create a new Table. The first way is to click on the Table icon in the toolbar and then click the location you want to place the report item. Alternatively, you can click the right mouse button, select the Insert menu and then the Table menu. The Table will then be inserted at the location of the mouse. Both of these methods will result in the following table wizard appearing.
Select the DataSet you want to use. The columns in that DataSet will appear in the DataSet Fields list. You'll need to create a new DataSet using the menu Data/DataSets/New... before creating the table if the datasets available don't provide the information you need.
Arrange Fields Across: create a standard tabular row column report.
Arrange Fields Down: creates two TableRows for each field: one for the field label and one for the label.
Arrange Fields Down (compress): creates a Table for each field. This field is an expression that result in an HTML format that concatenates the label and the field value together. The field is formatted using the 'html' pattern to display properly.
Select the columns and use the > or the >> buttons to select it. The field will disappear from the select list once it has been selected. Columns can be reordered by selecting the Table Column and clicking the Up or Down buttons. If you want to have total or subtotals on a Table Column you should click the column once to select the column then click again to check or uncheck the column.
To create a group select a column that you want to group by. The Grouping column should normally be the first column in the table. You may need to reorder the columns to achieve this.
If you select the Calculate Grand Totals check box the report will be generated with a table footer that totals the columns that you have checked in the Table Column list.