The first step in creating a document from an template is to open the template.
Click the Open button.Step 1
You can open the file in either of the following ways:
• Select the report name and then click the Open button.
• Double-click the report name.
In this example, you will use the first option to open the report template.
Click the Report_Template list item.Step 2
Click the Open button.Step 3
The template is opened. The next step is to import the data source table DW_BUSINESS_UNITS. Before importing the data, view the Field Explorer to check the status of the database fields.
Click the Field Explorer button.Step 4
Note that the Database Fields cannot be opened because there is no query and there are no fields to insert. You need to import data from the database.
Click the Database menu.Step 5
Click the Database Expert... menu.Step 6
Open the Create New Connection folder.
Click the expand button.Step 7
Open the ODBC (RDO) folder.
Click the expand button.Step 8
The ODBC (RDO) dialog box appears. Locate the PeopleSoft PeopleTools option to connect to it.
Click the vertical scrollbar.Step 9
Click the PeopleSoft PeopleTools list item.Step 10
Click the Finish button.Step 11
You are prompted to enter the password to connect to the database.
Enter the desired information into the Password field. Enter
Click the OK button.Step 13
The Database Expert dialog box displays the list of the existing queries. Locate the DW_BUSINESS_UNITS query.
Click the vertical scrollbar.Step 14
Click the DW_BUSINESS_UNITS list item.Step 15
Click the Add button.Step 16
Click the OK button.Step 17
Click the expand button.Step 18
View the query fields.
Click the expand button.Step 19
Next, insert the following fields in this report: BUSINESS_UNIT and DESCR.
Double-click the BUSINESS_UNIT list item.Step 20
Click the Details section of the report to place the field.
Click the Details cell.Step 21
The BUSINESS_UNIT field has been added. For the purpose of this exercise, the remaining field will be added for you to avoid repetition.Step 22
Notice that the fields have been added.
Click the Close button.Step 23
Next, enter summary information for the report. Summary information can include the date when the report was created and also the report title. Such information is helpful to anyone who refers to the report.
Click the File menu.Step 24
Click the Summary Info... menu.Step 25
Enter the desired information into the Comments field. Enter
Click in the Title field.Step 27
Enter the desired information into the Title field. Enter
Click the OK button.Step 29
Next, view the results.
Click the Refresh button.Step 30
Now that the report is complete, you need to save it with a different name so that you do not override the generic template.
Click the File menu.Step 31
Click the Save As... menu.Step 32
Enter the desired information into the File name field. Enter
Click the Save button.Step 34
You have successfully created a report from an existing report template.
Table of Contents Start Topic