9.4 Designing Custom Reports

To design custom reports, you must complete the general reporting setup (see Section 9.2, Setting Up Reporting), and then add the JReport Designer tool (purchased separately) to the ConsoleOne installation that you will use to design reports. You can then create your own custom report catalogs and report forms.

In This Section

9.4.1 Adding JReport Designer to Your ConsoleOne Installation

  1. From the Windows computer where ConsoleOne is installed, or from a Windows computer with a drive mapped to the NetWare server where ConsoleOne is installed, start a Web browser and go to the Novell ConsoleOne site.

  2. Locate and click the JReport Designer for ConsoleOne link.

    This should take you to a Jinfonet Web site where you can download a package called JReport Designer for Novell Reporting Services. This package is designed to integrate the JReport Designer tool with your ConsoleOne installation. If you can't find the JReport Designer link on the ConsoleOne site, check the site again later. At the time of this publishing, the availability date for JReport Designer hasn't been finalized.

  3. Follow the instructions on the Jinfonet Web site to download and run the JReport Designer for Novell Reporting Services setup program (DESIGNER.EXE or SETUP.EXE).

  4. Follow the prompts to complete the setup. When you are prompted for the installation directory, choose the location of your ConsoleOne installation.

    By default, this is:

    Local Drive

    C:\NOVELL\CONSOLEONE\1.2

    Network Drive

    SYS:PUBLIC\MGMT\CONSOLEONE\1.2

9.4.2 Creating a Custom Report Catalog

  1. Right-click the container that you want to create the Report Catalog object in > click New > click Object.

  2. Under Class, select Report Catalog > click OK.

  3. In Name, enter a name for the new report catalog object.

    Be sure to follow proper eDirectory naming conventions. (See “ Naming Conventions” in the Novell eDirectory Administration Guide.)

    Example: Custom XYZ Reports

  4. Select the location to store the files associated with the report catalog, and select the data source to be used by the report catalog.

    Click Help for details.

  5. Click OK.

  6. In the Add Table dialog box, select the database tables that your report forms will query > click Add.

    Repeat this action as needed.

    If you are using the Novell-defined NDS Reporting data source, most of the database tables correspond to eDirectory object classes.

  7. Click Done in the Add Table dialog box.

  8. Create the catalog's report forms as explained below.

9.4.3 Creating or Modifying Report Forms

  1. Right-click the report catalog object that contains (or will contain) the report forms > click Properties.

  2. On the Forms page, create and modify the report forms you want.

    Click Help for details.

    Clicking New or Open on the Forms page starts the JReport Designer tool. For information on using that tool, see the JReport User's Guide.