Creating a Data Object Report (DOR) in PCRE v2.4

Creating the DOR (.dor) file
A DOR (.dor) file is an XML description of the data source.

The DOR Design Utility is included in the PCREJavaClient.jar. This utility creates a DOR file by evaluating a Data Object. Running this utility results in the creation of a XML file in the format that the DOR to RPT Utility expects. The correct syntax for creating a DOR File from a Data Object is listed below.

DORSQLResultSetAdapter dorsqlresultsetadapter =
                   new DORSQLResultSetAdapter(rs);
DorDesignUtil dUtil = new DorDesignUtil();
dUtil.outputDorFile((DORDataSet)dorsqlresultsetadapter,
                   "h:\\dordev\\bikedata.dor");

Download the complete file: GenDOR.java

Running the DOR Design Utilty
The DOR Design Utility translates the DOR file into a blank report template (.rpt).

Once you have successfully generated the .dor file, you will need to run the DOR Design Utility as described on page 85 in the Developer's Manual. After following the installation instructions for the utility, you can run it by running <path_to_mobileapps>\mobileapps\DOR Report Utility\DorRptUtil.exe.

Final Report Design
Once you have created the empty DOR report template (.rpt), open it up in the Crystal Designer.

Click on the Insert tab at the top, and select Database Field.

Select all the fields you want to be in the report, and click Insert. The Designer will then all you to place the fields where you want them to be in the Designer. Once you have placed the fields, close the "Insert Fields" window. Format the fields and the report, and then save the report template.

Running the DOR Report
To run the report, you will need to set the private data to the PCREJob before starting the PCREJob.

job.SetPrivateData(resultSet);
. . . .
job.Start();

Download the complete file: DORReport.java