Example of Creating a Basic Quick Report
This example describes how to create a basic Crystal Report. The example
report shows the Foundation1 user properties for the current user.
Contents
- Start Crystal Reports and start the report wizard (by selecting Using the
Report Wizard radio button), if the welcome dialog doesn't appear start the
report wizard by selecting New.
- Select Create new connection /Oracle Server, and provide the Service, User ID
and Password in the connection dialog window and click "Finish". Add the FND_USER_PROPERTY view from the appropriate database user and click
Next >. If you are unable to see the Views
section, select File/Options... and choose the Database tab. Make sure the Views is checked.
Note: FND_USER_PROPERTY is used as an example here and not necessary
to include in your own report.
- Add the IDENTITY, NAME and VALUE fields from the FND_USER_PROPERTY
table/view by selecting the field and clicking on the ">" button.
- Click Finish.
- Set the alias for the databases (Database/ Database Export...).
Append a backslash (\) to the end of the FND_USER_PROPERTY, by selecting the
view from the "Selected Tables:" and pressing F2 button. Click OK.
- Layout the report the way you want it to look. In design mode it could
look something like this.
- Make sure the "Save Data with Report" option is not checked in the File
menu. Save the report.
- Previewed by to tool, it could look something like this.