Use the Layout window to design the layout of your report. When you complete a query, the Layout window automatically displays. You can also access the Layout window for a completed report by choosing File, then Open and opening the desired file.
When you first access the Layout window, the default report layout displays the fields defined in your query in the Details section and the current date and page number in the Page Header section. The rest of the information displayed depends on the options you specified in the Configure Default Layout dialog box as you defined your report. You can modify the default layout as desired.
To modify the default layout configuration, choose Layout, then Default Layout, then Configure.
To clear the layout and start from scratch, choose Edit, then Clear All.
To return to the default layout after you make changes, choose Layout, then Default Layout, then Rebuild.
To undo an edit in the layout, selectEdit, then Undo or press [Ctrl+Z].
The Tabular, Chart, Cross-tab, and Label reports each have separate layouts. Since the Export report exports data for use by other applications, it does not have a layout. The section names for each report type are as follows:
Report Header—Contains information that appears before the actual report. You can use the Report Header to customize the first report page. Unlike the Page Header (which appears at the top of every page), the Report Header appears only once. To create a "cover page", insert a page break after the Report Header.
Page Header—Typically contains information such as page numbers, the current date, column headings, and images. The Page Header prints at the top of every page in the report.
Group Header—Appears only if you defined a group. The header information for the group prints in this section.
Details—The body of the report. This is where you insert most of your database fields; however, you can also insert fields in the Header and Footer. If you defined subqueries, each subquery has its own Details section.
Group Summary—Appears only if you defined a group. The summary, such as totals or averages, prints in this section for the specified group.
Query Summary—Contains summary information such as totals, averages, charts, and cross-tabs. This section executes after all the data rows have been executed.
Page Footer—Typically contains information such as page numbers and the current date. The Page Footer prints at the bottom of every page of the report.
Report Footer—Contains information that appears after the actual report. You can use the Report Footer to customize the last report page. Unlike the Page Footer (which appears at the bottom of every page), the report Footer appears only once.
Report Header—Contains information that appears before the actual report. You can use the Report Header to customize the first report page. Unlike the Page Header (which appears at the top of every page), the Report Header appears only once. To create a "cover page", insert a page break after the Report Header.
Page Header—Typically contains information such as page numbers and the current date. The Page Header prints at the top of every page of the report.
Group Header—Appears only if you defined a group. The header information for the group prints in this section.
Details—Used to insert any additional database columns or text into the report.
Group Summary—Appears only if you defined a group. The summary, such as totals or averages, prints in this section for the specified group.
Query Summary—Used to insert the chart that you wish to display. Charts present a visual summary of an aspect of your report that you would like to highlight.
Page Footer—Typically contains information such as page numbers and the current date. The Page Footer prints at the bottom of every page of the report.
Report Footer—Contains information that appears after the actual report. You can use the Report Footer to customize the last report page. Unlike the Page Footer (which appears at the bottom of every page), the report Footer appears only once.
Cross-tab Report section names:
Report Header—Contains information that appears before the actual report. You can use the Report Header to customize the first report page. Unlike the Page Header (which appears at the top of every page), the Report Header appears only once. To create a "cover page", insert a page break after the Report Header.
Page Header—Typically contains information such as, page numbers, images, and the current date. The Page Header prints at the top of every page of the report.
Group Header—Appears only if you defined a group. The header information for the group prints in this section.
Details—Used to insert any additional database columns or text into the report.
Group Summary—Appears only if you defined a group. The summary, such as totals or averages, prints in this section for the specified group.
Query Summary—Used to enter the cross-tab information. Cross-tab information includes summaries that highlight specific data in a report.
Page Footer—Typically contains information such as page numbers and the current date. The Page Footer prints at the bottom of every page of the report.
Report Footer—Contains information that appears after the actual report. You can use the Report Footer to customize the last report page. Unlike the Page Footer (which appears at the bottom of every page), the report Footer appears only once.
Details—Used to position the data for one label. SQR Production Reporting Studio uses this layout for all the labels, and automatically prints the correct number of rows and columns to fill up the page according to the layout specifications you defined in the Label Setup tab (Report, then Report Properties, and then Label Setup) and the Labels dialog box (File/Edit, then Preferences, and then Labels).
Using the Layout Window Explorers
Inserting Objects into the Layout