You can create a report in Crystal Reports if a report template or report does not exist that fits your needs. Creating your own report in Crystal enables you to use a query from PeopleSoft and customize the field layouts and formatting.


The basis for any report in Crystal Reports is a PeopleSoft query. Instead of manually entering data into a report, the system retrieves it through the PeopleSoft query that you link to the report.


In this topic, the Accounting Department requests a Region report that includes SetID, Region, Effective Date, Effective Status, Description, and Short Description. You need to layout fields on the report based on the AD705__REGION_TABLE query. You will add a report title and format the fields within the report, as required. Additionally, you will add date and page number fields to the report.

Table of Contents