Including Columns in the Default Report Layout

When you add database columns to your query, SQR Production Reporting Studio automatically includes them in the default report layout. This is indicated by the Yes that appears under the Layout heading in the Fields tab.

Occasionally, you may want to include a column in your query, but do not want it to appear in the default report layout. For example, if you plan to save a chart or cross-tab as an Interactive Reporting client analysis file, you may need to select a column to generate the desired data; however, you may not want to display the column in your Production Reporting report.

To specify whether to include a column in the default report layout:

Double-click next to the database column under the Layout heading to toggle between Yes and No.
Select the column, click Edit to access the Layout Settings dialog box, and add or remove the check next to Include in default layout.

Excluding a column does not prevent you from adding it to the layout at a later time, it simply excludes the column from the default layout.

Note:

SQR Production Reporting Studio uses all the fields that have Include in the default layout selected to rebuild the default layout when you select Layout, then Default Layout, and then Rebuild in the Layout window.