Group Tab (Item Properties Dialog Box) - Intergraph Smart 3D - Help - Hexagon PPM

Intergraph Smart 3D Reports

Language
English (United States)
Product
Intergraph Smart 3D
Subproduct
Drawings and Reports
Search by Category
Help
Smart 3D Version
13
SmartPlant Foundation / SDx Version
10

Sets grouping options for the selected item in the left pane of the Excel window. The grouping options define the properties that group the input data into composite rows when one row of output is based on multiple rows of input, such as in MTO reports.

Many of the delivered reports use grouping definition. The graphics below show the properties identified by the delivered Piping Pipe Total Length Sorted by NPD report.

Use Grouping

Enables the controls on this tab.

Grouping By

Attributes

Lists the attributes available for grouping. You use the single arrow buttons to move individually selected attributes in the direction of the arrow, or use the double arrow buttons to move all attributes in the direction of the arrow.

Attributes used for grouping

Lists the columns you want to use for grouping. You can move items back and forth between the two main boxes on this dialog box by using the arrow keys in the middle of the dialog box.

Item Tag Number

Style

Specifies the style applied to the item tag number. Values are Numeric (default setting) and Alphabetic.

Base value

Specifies the counting starting point for the item tag number. The default is 1 for Numeric and A for Alphabetic. If the style is Alphabetic, only the letter values A through Z will be accepted, and you are limited to six letters in length. Lowercase characters are changed to uppercase automatically.

Step

Identifies the counting increment value. The default is 1. This field is numeric only.

Is continued?

If checked, specifies that the numbering starting point continues from the previous item tag number in the report layout. This checkbox overrides the Base value setting. Default is unchecked.

Column name

Identifies the name of the item column in the spreadsheet.

Is Locked?

Specifies whether the cell is locked or not. You can lock cells to prevent changes. For more information about locking cells and protecting data, see the Microsoft Excel Help.

Quantities

Delete

Removes the selected quantity attribute row from the Quantities table.

Quantity attribute

Provides a dropdown list of all report attributes. You select an attribute for which you want to include totals and sum totals in the specified total column.

Quantity total column name

Specifies the name of the quantity column for the selected attribute.

Is Locked?

Specifies whether the cell is locked or not. You can lock cells to prevent changes. For more information about locking cells and protecting data, see the Microsoft Excel Help.

See Also

Item Properties Dialog Box