Report

Go Up to Available object actions by DBMS

DBArtisan offers two basic object reporting options:

• You can generate a simple summary of all objects of a given type for a single database. For each object, the report contains similar information to that shown in the Datasource Explorer for that object type. The report opens in a built-in HTML browser. You can find data in the report, save it, or print the report.
• You can generate a detailed report of one or more objects of a given type for a single database. For each object, the report contains information similar to that available in the object editor for that object type. In addition to opening in the built-in HTML browser, the report file is written to an .htm file.

Platform Availability

• DB2 LUW
• DB2 z/OS
• MySQL
• ORCL
• SQL SVR
• SYB ASE

To Generate a Summary Report on all Objects of a Selected Type in DBArtisan

1. On the Datasource Explorer, select a node corresponding to the object type you want to report on or on the Datasource Navigator expand that node.
2. Right-click an object, and then select Report from the context menu.

   The Generate Report dialog opens.

3. Select the Summary Report option and click OK.

To Generate a Detail Report on One or More Objects

1. In DBArtisan, on the Datasource Navigator/Explorer, select the target object node.

2. Right-click one or more selected objects, and then select Report from the context menu.

3. If using DBArtisan, select the Detail Report option and click OK.

The Report dialog opens.

4. In Report Home Page File Name, type the report name or click Browse to locate the report.

5. Use the Append date and time stamp to report file name and Save report in date specific folders controls to ensure that the disk files are not overwritten each time you generate reports against the specified file name.

6. In Report Title, type the title that is to appear in the report.

7. If you selected multiple objects, use the Report Options controls to specify a Single HTML File for All Objects or Separate HTML Files for Each Object.

8. Click Execute.

The report opens in the built-in browser and writes a copy to disk.