Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Contents of the Print Data Dictionary Report Screen

Use the fields and options to configure the Print Data Dictionary Report screen.

Print Data Dictionary Report

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Use the fields in this group box to specify the module, tables, and/or columns you want to include in this report.

Module

Field Description
Option

Use the drop-down list to select the desired range of Costpoint application modules you want to use. All data dictionary information associated with this module are included in this report. The following options are available:

  • All: Select this option to include all available records. The Start and End fields are disabled for this option.
  • One: Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
  • From Beginning: Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
  • To End: Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Start

Enter, or click  to select, the starting module name, as applicable.

End

Enter, or click  to select, the ending module name, as applicable.

Table

Field Description
Options

Use this drop-down list to specify the Costpoint database table(s) you want to include on this report. The following options are available:

  • All: Select this option to include all data dictionary tables associated with the Costpoint module you specified in the Module drop-down list. The unlabeled field on the right is disabled for this option.
  • One: Select this option to include one specific data dictionary table on this report. Use the unlabeled field to the right to enter a table name.
  • Begins With: Select this option to include all data dictionary tables that begin with a specific set of characters. Use the unlabeled field on the right to enter a value.
  • Contains: Select this option to include all data dictionary tables that contain a specific set of characters within the table name. Use the unlabeled field on the right to enter a value.

Column

Field Description
Option

Use this drop-down list to specify the data dictionary table columns you want to include on this report. The following options are available:

  • All: Select this option to include all columns associated with the data dictionary table(s) you specified in the Table drop-down list box. The unlabeled field on the right is disabled for this option.
  • One: Select this option to include one data dictionary table column on this report. Use the unlabeled field to the right to enter a column name.
  • Begins With: Select this option to include all data dictionary table columns that begin with a specific set of characters. Use the unlabeled field on the right to enter a value.
  • Contains: Select this option to include all data dictionary table columns that contain a specific set of characters within the table name. Use the unlabeled field on the right to enter a value.

Sort By

Use the drop-down lists in this group box to determine the primary sort, secondary sort, and page break settings.

Field Description
1st Sort

Use this drop-down list to select whether to primarily sort this report by Table or Module.

2nd Sort

Use this drop-down list to select whether to sort this report again, based on your selection in the 1st Sort drop-down list. The sort options are by Primary Key or Column Order.

Page Break

Select this check box to insert a page break between tables or modules depending on your selection in the 1st Sort drop-down list.

Options

Use this group box to specify additional options.

Show

Use the check boxes in this group box to include table and/or column information on this report.

Field Description
Table Information

Select this check box to include all data dictionary table information on this report.

Column Information

Select this check box to include all data dictionary table column information on this report.