Previous Page Next Page
Configuring the reference table
With the development of reports and catalogs, the relationships among the catalog resources may become increasingly complicated. You might be wondering if and where an SQL or a formula is used by a resource in a catalog or report. You might hesitate to rename or modify a resource because you don't exactly know what other resources are currently using it and, and if you change it what result it would cause.
To help you manage catalog resources, JReport provides you with a tool - the reference table. JReport monitors the resource reference information in the catalog and stores this information in the reference table. You can select the resource types that can be registered in the reference table. With the reference table, when you rename a resource object, JReport Designer will scan the reference relationships between it and other resource objects. It will then prompt you to update the changes in the resources that reference the object, helping you reduce the risk of a missing resource causing a failure in another report.
Before JReport can start to monitor and record the resource reference information in the reference table, you must first have the reference table configured by choosing the resource types that are to be added to the table. Then JReport will monitor the reference relationships among objects of these resource types and store the relationship information in the database.
To configure the reference table:
In order to improve product performance and provide you with more flexibility, JReport allows you to choose the resource types that you want to monitor by yourself. JReport will then only monitor the referencing relationships between the resource types that you have selected. The resource types that have not been selected will not be monitored, even if they may have referencing relationships to the selected resource types. Therefore, if you are not sure whether the resource types you have selected hold all the possible reference relationships within themselves, it is recommended that you select as many resource types as possible to avoid incomplete information.
For example, in the Reference Table Configuration dialog, selecting only the formula resource type means that for a formula, only the formulas referencing this formula will be recorded in the reference table, although other resources such as queries, summaries, and reports which are also using this formula will not be shown in the reference table. If you rename this formula, you will only be prompted to update the change in the formulas using it, and any other resources using it will be ignored.
After you have configured a reference table, you can view the referencing relationships for a specific resource object. To do this:
Tip: In the Reference Entities window, you can right-click any of the query, formula, parameter or summary entity which uses the specified resource object to edit it, and right-click any report entity to open the report.
The reference table information is stored in a database, which provides reliable stability. However, in some circumstances you may need to refresh the reference table to retrieve the correct reference relationship information. To do this, on the Catalog Manager toolbar, click Refresh Reference.
You can also export the reference table information to a text file as follows: click Export Reference on the Catalog Manager toolbar, then in the Save Reference dialog, specify the location where you want to save the file and click Save.