Home Tab Navigation

Format Group

The Format options determine the file format output. HTML format is selected by default.
Click the dropdown arrow to display alternate file format output options.
Modify the report output format, as desired.

Leaving the format output as HTML during query development makes the process move a lot quicker. This is due to the formatting that has to take place to display the data in other formats. If you need Excel output, it is recommended to leave the format set to HTML and later, after the report is built and query is tested, change the output to Excel to get the desired format.
File is used to create hold files and Chart can be used to create a chart from the data in the report.

The Design group determines the design mode that displays when building your report. Live Preview is the design mode selected by default. Query can be used to increase response time when adding fields to the report.
Select an alternate design mode, as desired.

Query and Live Preview alter your workspace, while selecting Document places you into a different, more advanced mode where you can place many queries, charts or reports together.
Click to select Use Sample Data for quicker development as you design your report. Data from Source is selected by default.
As desired, modify the Records selection to set the number of lines of data that display as you design your report. To modify, click the Records dropdown and select an alternate numeric option.

Use the Filter group to create a new filter, by clicking the Filter option. See the article on Filtering a Report for more details.

Use the Report group to enhance the format of the report in several ways.
Explore the Theme and Style options to modify items such as font size, font type, alignment, etc.
Click Banded to identify a color scheme to apply for banded rows and columns to your output data.
Click the Header & Footer dropdown to apply Report and/or Page Headers/Footers, as desired.
Type the desired text in the Header & Footer dialog box. Use the drop down on the far right to insert preformatted text content; for example, the date.
Click the Column Totals dropdown to select an option from the dropdown, as desired.
Click Row Totals to show row totals, as desired.