BackPrevious Page Next PageNext

Managing the Data Resources in a Catalog

Adding a data resource

Editing a data resource

Duplicating a data resource

Renaming a data resource

Deleting a data resource

Setting data resource properties

Setting default property values for a data resource

Filtering the data resources

Searching for data resources

The Catalog Manager provides a hierarchical view of the data resources in the current catalog. You can use it to add, remove, or modify the data resources in a catalog.

Catalog Manager

Adding a data resource

Although there are a variety of data resources in a catalog, the ways you create them are fairly similar.

  1. In the Catalog Manager, expand the catalog data source where the resource is to be added.
  2. Select the data resource node of the type that you want to create, then right-click it and select Add/New XXX from the shortcut menu, or click the appropriate command on the Catalog Manager toolbar. The corresponding resource editor or dialog is then displayed.

    For example, if you want to create a summary, right-click the Summaries node and select New Summary. The New Summary dialog then appears for creating the summary.

Editing a data resource

Select the data resource that you want to edit, then click Edit on the Catalog Manager toolbar or right-click it and select Edit XXX from the shortcut menu. In the corresponding editor or dialog, edit the resource as required.

In most cases you can also edit a data resource by using its right-click Edit XXX menu command from the Data panel, which only shows data resources actually available for use in the selected report component.

Duplicating a data resource

Select the data resource you want to duplicate and click Copy on the Catalog Manager toolbar. To paste it, click Paste on the toolbar.

Renaming a data resource

Click twice on the name of the data resource you want to rename, when the name text box becomes editable, input the new name and click outside the name text box to confirm the change.

You can also rename data resources by editing their Name property in the Properties sheet.

Tip: Renaming a data resource will impact other resources that use it. You can configure the reference table to monitor the reference relationships between resources.

Deleting a data resource

Select the data resource you want to delete and click Delete on the Catalog Manager toolbar, or right-click the data resource and select Delete from its shortcut menu.

Setting data resource properties

When you select a data resource and click Show Properties on the Catalog Manager toolbar, the property list of the data resource is displayed in the Properties sheet on the right. See Catalog Data Object Properties for detailed explanation about properties of each data resource type.

By default, the properties in the Catalog Manager cannot be edited. To make the properties editable:

  1. On the Catalog Manager toolbar, click Options.
  2. In the Options dialog, select Catalog in the Category box.
  3. Uncheck the option Forbid editing data object properties, then click OK in the dialog to confirm the change.

Setting default property values for a data resource

You can set the default values for the properties of data resources in the Catalog Manager, so that you do not need to set them each time you insert them into your report. The data resources that can have default values are formulas, parameters, summaries, table/view columns, SQL columns, stored procedure columns and user defined data source columns. Query columns do not support this feature. Data resources that are used in a business view inherit their properties from the underlying objects.

To set default values for a data resource:

  1. Make sure that the property values are editable in the Catalog Manager.
  2. Select the data resource with the properties you want to set, click Show Properties on the Catalog Manager toolbar, or right-click the data resource and select Properties from the shortcut menu.
  3. The properties listed in the Properties sheet are the default values for the selected data resource. You can change the property values here, and the next time you insert the data resource into a report, the values you specify here will be used as the default values.

Filtering data resources

You can filter the data resources in the Catalog Manager to show only the required resources.

  1. In the Catalog Manager, click Filter View on the toolbar. The Filter View dialog appears.

    Filter View dialog

  2. Provide a filter condition in the Filter Expression text box. Use "*" to stand for any string, and use "?" to stand for any character. You can also leave this text box blank.
  3. Select the Case Sensitive checkbox if you want JReport to distinguish between uppercase and lowercase characters when filtering.
  4. In the Select the elements to include in the view box, check the resource types you want to remain in the Catalog Manager resource tree. Click the Select All/Deselect All button to select/deselect all the resource types.
  5. Click the OK button to filter the resources.

    The filter result will be the union of the resources that match the filter condition and the selected resource types.

Searching for data resources

When there are many resources in a catalog, sometimes you may find that it is difficult to locate where a resource is. The Catalog Manager provides you with a search function which enables you to search resources in the leaf nodes of the catalog data resource tree.

  1. In the Catalog Manager, click Search on the toolbar. The Search dialog appears.

    Search dialog

  2. Provide a search condition in the Search Expression text box. Use "*" to stand for any string, and use "?" to stand for any character.
  3. Select the Case Sensitive checkbox if you want JReport to distinguish between uppercase and lowercase characters when searching.
  4. Specify the search scope:

    For example, if you want to find the DBField Customer Name in the Queries node, select the node in the Catalog Manager, then in the Search dialog, input Customer Name in the Search Expression field and check the scope as Selected Resource.

  5. Click Search to start searching.

    All the matched results are listed in the Search Result panel which has three columns: Resource Name, Resource Type and Resource Path. You can sort the search results alphabetically by clicking any column header. Select an item from the Search Result panel, and the corresponding resource is then highlighted in the Catalog Manager.

    Search Result

BackPrevious Page Next PageNext