SheetSets

In this topic: Hide

 

SheetSets are groupings of sheets that have similar characteristics such as size or report format. Sets can be created and saved, providing an efficient way to manage multiple sheets. Each SheetSet contains a Title Sheet that cannot be renamed or deleted, along with any number of other sheets that can be renamed, modified, and deleted.

To modify the properties of a SheetSet using one of the following options:

·        Right click on the label of the SheetSet in the Sheets tree and select Properties from the context menu

·        Double click on the SheetSet label in the Sheets tree

Click on the image below to learn more about the various sections of this dialog.

1. Label

Modify the SheetSet label.

2. Size

Select a preset size for all the sheets in the SheetSet, or select Custom and enter a height and width for a specific Sheet size (in Millimeters).

·        Height - Enter a numeric value for a custom sheet height.

·        Width - Enter a numeric value for a custom sheet width.

3. Orientation

Modify the orientation of the sheets in your SheetSet using the Orientation menu.

·        Portrait - The height of the Sheet is greater than the width.

·        Landscape - The width of the Sheet is greater than the height.

4. Interactive Usage Type

The Interactive Usage Type marks how the SheetSet will be used in CM4D Interactive. SheetSets in CM4Di templates must be modified to be either a Report, Drill Down, or Summary type. SheetSets that are not used in CM4Di do not need to be updated; unused SheetSets can be set to the None usage type.

·        None - SheetSets that will not be used in a CM4Di document can be set to None, the default usage type for new SheetSets.

·        Report - Required for a SheetSet to use Auto Reports in CM4Di.

·        Summary - will be included in the Report menu, but will not have an Auto Report or a DataSet. A Summary report simply displays data.

·        Drilldown - used to assign a SheetSet as a Drilldown Report in CM4Di. As long as the Interactive Usage Type is set to Drill Down, the SheetSet will appear in CM4Di as a Drill Down report.

5. Array Row Adjust

See the topic, Array Sheet.

6. Sheet Propagation

Sheet Propagation can be used to facilitate building multiple sheet reports that display annotation for one Feature (from a DataSet) per Sheet. See the Sheet Propagation Tutorial to learn how to set this up.

·        Number of Total Sheets - enter the number of sheets you want to have total, including any sheets that you have already created. If you have more than one Sheet created before running the Sheet Propagation, all but the first sheet will be overwritten based on whatever is in the first Sheet.

·        Sheet Label Prefix - enter a prefix label for the Sheets to be created during the Propagation process. For example, if you leave in the default prefix "Sheet ", CM4D will create "Sheet 1", "Sheet 2", "Sheet 3", etc. up to the Number of Total Sheets.

7. SheetSet Management

Managed

Makes the SheetSet available for use in Managed Reports. Check the box and then click Setup to configure the management settings. See the topic, Managed SheetSets for more information.

Run AutoReport

Re-runs AutoReports that do not include a View when printed by Scheduler or Web.

When a SheetSet is run through Scheduler, AutoReport can be triggered to re-run to accommodate whatever data is included in the report at the time it is generated. If the report does not contain a View (which is the typical use; a view has its own option to re-run the AutoReport), you can check this box to trigger the AutoReport to rerun when printed in Scheduler or Web.