Creating reports

Command

Workspace: Path

Create Report

Fundamentals, Design Suite, Architect, Landmark: Tools > Reports

Spotlight: Spotlight

The Create Report command allows you to select a group of objects from a drawing and then create a worksheet based on data that is associated with the objects (such as a price, or the object's class). You can either create a new report or append database rows to an existing report. For more information about how to attach data to objects, see Attaching record formats to symbols, objects, and materials.

This method of Creating worksheets may be preferable to creating a worksheet from scratch, if you're not comfortable directly editing criteria and worksheet functions.

To create a report from objects in a drawing:

Select the command.

Alternatively, from an existing worksheet, right-click a spreadsheet row number and select Create Report, or right-click a database row number and select Edit Report. The Create Report (or Edit Report) dialog box opens.

If Vectorworks Design Suite is installed, you can create a preformatted report. See Using preformatted reports.

Click to show/hide the parameters.Click to show/hide the parameters.

Parameter

Description

Report type

(new worksheets only; Vectorworks Design Suite product required)

Select Custom Report to specify which objects, fields, and functions to display in the report.

Select Preformatted Report to select from a list of several standard reports; see Using preformatted reports.

Title

(new worksheets only; Vectorworks Design Suite product required)

Enter a report title. If you append the report data to an existing worksheet, this title is added to a spreadsheet cell above the database rows that are appended.

Criteria

Criteria settings determine which drawing objects will be listed as sub-rows in the report—for example, all objects with a cabinet record attached to them.

Basic Criteria

Creates a report based on one specific criterion. From the pull-down list, select the criterion—for example, a certain type of object, such as a symbol. If you select Objects with a record, also select the record from the list that displays.

Include subparts

If a parent object (such as a wall) matches the criteria, includes subparts (such as wall components) that match the criteria. In the report, subparts are grouped under the parent object.

If the criterion is Type, all subparts are included regardless of their object type.

Include parent object

If Include subparts is selected, includes the parent object of subparts that match the criteria, even if the parent object doesn't match the criteria

Search within

If desired, check the options to include objects that are part of symbols, plug-in objects, viewport annotations, and design layer viewports (Vectorworks Design Suite product required).

Advanced Criteria

Creates a report based on multiple criteria. Click Edit Criteria and set the criteria as described in The Criteria dialog box.

Columns

Column settings determine which information displays in each column of the report—for example, the description, price, and layer location for each cabinet in the drawing.

Select from

From the list on the left, select the general type of data to work with: records, functions, or styles. If Vectorworks Design Suite is installed, you can also select from data sheets, and IFC or COBie data.

From the list on the right, select a more specific category within that data type. To filter a long list, enter text in the search field above the list.

Possible Columns

The available columns depend on the selections in the Select from lists. To filter a long list, enter text in the search field above the list.

Report Columns

Lists the columns that are currently selected for inclusion in the report, in the order in which they will appear. To change the order, click on the # column and drag the item to the desired position in the list.

Add >> / Add All >>

To add a column to the report, select it in the Possible Columns list and click Add. Click Add All to move all the columns to the Report Columns list.

<< Remove /
<< Remove All

To remove an item from the report, select it in the Report Columns list and click Remove. Click Remove All to move all the columns to the Possible Columns list.

Add Custom Field

Opens the Custom Field dialog box, to add a custom field to the report. Enter a Name/Label for the field. Click Insert Record Field/Function to open the Select Function dialog box, and select from the functions or fields available (see Inserting a function). Alternatively, make entries in the Formula field directly.

Format Field

Opens the Format Field Column dialog box, to apply appropriate formatting to the column. See Formatting worksheet cells for Number Format descriptions. Select Sum values if desired; see Cell context menu.

Edit

For a custom field, opens the Custom Field dialog box to allow editing.

For one of the parameter-based worksheet functions, opens the Edit Parameter dialog box to enter a parameter. See Worksheet functions.

Summarize items with the same

Select the check box to summarize objects that contain the same value for a specified field, rather than creating a new database sub-row for each. Select the field to summarize from the drop-down list.

Place report on drawing

Places the report on the drawing when it is created (not available when accessed from an existing worksheet)

Append to existing report

Appends the information to a report in this file; select the target report (not available when accessed from an existing worksheet)

Specify the report criteria and columns, and click OK to create the report.

If you opted to place the report on the drawing, click in the drawing to place it. Otherwise, the worksheet opens automatically. The top row of the worksheet contains a title for each column selected. Next is a database header row (indicated by a diamond next to the row number) that contains sub-row totals for each column. Beneath the header row are sub-rows for each object or symbol in the drawing that matches the report criteria.

To append additional reports to the worksheet, repeat step 1 and select the Append to existing report option before you click OK to create the report.

To edit the report data, right-click a database row number and select Edit Report.

Once all the data is added, edit the worksheet. For example, add rows or columns, change the text format, or add color.

Editing worksheets

Formatting worksheet cells

Using preformatted reports

Tutorial: Creating a wall schedule worksheet

 

Was this page helpful?