Design SuiteProject revision and issue history worksheets

The Title Block Manager creates worksheets with the information from the data records and record formats maintained by the title blocks marked for inclusion in the Title Block Manager operation.

Revision and issue data can also be extracted from title block borders using the Create Report command; see Creating reports.

The worksheet appearance (such as font, color, and so on), field label text, and design company information including a logo can be customized (see Concept: Worksheet overview) and saved into the user folder to be used for future reports. However, rows should not be added or deleted in the top section of the worksheet that displays the issue dates and approvals, since the worksheet formulas depend on these rows.

ws_IssueRpt_OnePg.png 

When the issue history and revision history reports are run, the Title Block Manager checks to see if the report already exists in the file; if so, it writes new data into the existing worksheet. If the report doesn't already exist in the file, the Title Block Manager first checks the user folder, and if the report doesn't exist there, it checks the workgroup folder. See Creating custom resource libraries for information about saving resources to the user and workgroup folders. If there is no existing report in any of those locations, the default report resource is imported from the library. The default worksheets have the following names and are available in the default content (Vectorworks Libraries\Defaults\Reports_Schedules\Title Block Reports.vwx).

Title Block Project Issue History

Title Block Project Issue History Single Page

Title Block Project Revision History

Title Block Project Revision History Single Page

Sheet Revision Log

The name of the worksheet resource in the drawing file is automatically incremented with a suffix: "-1" if the report is all on one page, and a series of numbers (-1, -2, -3 and so on) for each page if Create standard worksheet is selected. The sheet revision log has the suffix of the report run date.

To create an issue or revision report:

From the Worksheets section of the Title Block Manager, click on the kind of worksheet to create and set the parameters.

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

Parameter

Description

Create/Update project issue history/project revision history/sheet revision log

Creates/updates a project issue history worksheet, a project revision history worksheet, or a sheet revision log worksheet. You can create either a database worksheet or standard worksheet (see Concept: Worksheet overview), which is saved as a resource in the file, accessible from the Resource Manager.

The sheet revision log is a comprehensive log of all revision records on all sheets in the project, sorted by sheet ID and by revision order. Running this log after the initial creation updates the existing log.

Worksheet Name

Enter a name

Limit the number of the reported issues

(Project issue/revision history worksheets only)

Displays only a certain number of the most recent issues/revision; enter the number of issues/revisions to list on the report

Sort By

Select the sheet sorting order for the report

Create database worksheet

Creates a database worksheet on a single page; this option reports only on title blocks in the active file

Criteria

Optionally, to filter the report to display only certain title block borders, select the criteria. To manage the list of criteria available for selection, see Managing title block report criteria.

Create standard worksheet

Inserts the data into the worksheet and creates additional pages as needed to accommodate all the rows of title block border data; this is useful if a project has too many rows to fit neatly on a printed page. 

IssueRpt_MultiPgs.png 

The worksheet will contain information from title blocks in external files only when this option is selected.

Start at Row

If creating a multiple page worksheet, specifies the first row of the section in the worksheet to divide across multiple pages

Row Count

Specifies how many rows after the Start at Row to put on each page of the worksheet

Put the worksheet data on a sheet layer

Includes the worksheet as a graphic object on a sheet layer; double-click the object to open the worksheet for editing (see Editing worksheets)

Sheet Number

Select the sheet number

The worksheets are created after the Title Block Manager dialog box closes.

Managing title block report criteria

The Title Block Criteria Manager lets you create criteria to select specific title block borders for reports. Create as many criteria as needed, or import them from another file.

To add, edit, delete, or import title block report criteria:

From the Title Block Manager, click the Criteria list, and then click Title Block Criteria Manager.

The Title Block Criteria Manager dialog box opens, and displays the current criteria by name and criteria formula.

Do one or more of the following:

Click Add or select a line item and click Edit; specify criteria for which title block borders to include in the report, as described in The Criteria dialog box. This may look something like the example below.

Delete a selected criteria item.

Click Import and browse to an existing Vectorworks file, and import the criteria from it.

Click a line item, and then click the icon to the right of the name to edit it; new criteria are automatically given a default name and must be renamed.

Create as many criteria as needed, and then click OK.

The criteria are available for selection in the Criteria list when you create a report.

Project revisions and issues in custom worksheets/reports

To display revision or issue data in a worksheet with a database row (see Selecting a function or field for a database column), use the following formulas:

='Title Block Revision Data-<Revision Index>'.'<Field Name>', where <Revision Index> is the index of the revision starting from 1 for the latest created revision and <Field Name> is one of the following: Number, Date, Note, Approval, Zone, Recipients, Publish Date.

Example: ='Title Block Revision Data-1'.'Approval'

='Title Block Issue Data-<Issue Index>'.'<Field Name>', where <Issue Index> is the index of the issue starting from 1 for the latest created issue and <Field Name> is one of the following: Number, Date, Note, Approval, Zone, Recipients, Publish Date.

Example: ='Title Block Issue Data-2'.'Date'

Concept: Title block borders

Creating title block borders

Batch publishing

 

Was this page helpful?