Use the Layout page to create the data and look of the report. This page is different depending on the type of report you are making:
Adding data (Advanced and Express Reports)
Add data fields to display in the output of the report. Each data field is a column of associated data values, each corresponding with a row in the category. In the Preview pane, each data field is given a header, and preceded by some placeholder values indicating how the values from the field will look.
To show a formula instead of the data field, click the formula
icon, then use the formula editor to make a
data formula. See Formulas for more
information.
Grouping data
If you have Sorts then you can group your data fields by one or more sort fields. To add a group:
icon to make a formula for the text.
Page header and footer
A page header is inserted by default with the name of the report. To remove the header, clear the Page Header check box. To edit the header, click Page Header. The following options are available:
To include the report title at the top of every page, select the Include title at the top of every page check box.
If you have an image in the header, choose whether the title is in a column to the Left or Right of the image, from the Position list. Choose how many columns the title spans.
To include an image at the top of every page, select the Include image at the top of every page check box, then click Change Image to upload an image from your computer.
If you have a title in the header, choose whether the image is in a column to the Left or Right of the title, from the Position list. Choose how many columns the image spans.
To add a footer to every page, select the Page Footer check box. To edit the footer, click Page Footer. The following options are available:
To include the page number at the bottom of every page, select the Include page number at the bottom of every page check box.
If you have an image in the footer, choose whether the page number is in a column to the Left or Right of the image, from the Position list. Choose how many columns the page number spans.
To include an image at the bottom of every page, select the Include image at the bottom of every page check box, then click Change Image to upload an image from your computer.
If you have a page number in the footer, choose whether the image is in a column to the Left or Right of the page number, from the Position list. Choose how many columns the image spans.
To include a summarization of all the data fields at the end of the report, select the Grand Total check box.
Styling the report (Express Reports)
You can do all your styling for Express Reports in the report wizard. To style a cell, click the cell and then choose from the available options:
To change the text in a header or footer, double-click the cell and edit the
text. To insert a blank column between two data fields, click
Add Blank, then drag the column
between the two fields. To resize columns, drag the left or right border of the
column.
Premade themes
If you want to use a premade theme, or use one as a starting point for your customization, select a theme from the Theme list.
Caution. Selecting a premade theme will override your
current cell styling. If you want to undo a theme selection, click the Undo
icon, or press Ctrl-Z.
What are Crosstabs?
Crosstab reports are an easy way to do calculations of data when you have one or more groups, and you want to make calculations on subdivisions of the data for each group iteration. Crosstabs extend horizontally for each subdivision so that you can fit many calculations in a smaller space.
The Crosstab wizard creates a Crosstab "widget" in an Advanced Report. When you finish the wizard, the report opens in the Report Designer. To edit the crosstab in the designer, double-click the crosstab.
For instructions on making crosstabs, see Crosstabs.