Report Writer Exercise

Objectives:

1. To explore the program structure and various commands of Ingres Report Writer.
2. To produce printed output form the Library database.

Compiling externally written report code

1. Save this report writer code in a file called books.rw file
2. Compile the report into the database using the command
   sreport dbname books.rw
   on a command line. You do not need to leave Ingres/Menu to do this. Simply start another window to gt a command line.
3. Back out of the RBF - Report Catalog and reinvoke it. This will refresh the available reports. You will see that booksinprint has been added to the list.
4. Run the report sending the output to the default printer. Compare the output with the books.rw source code. Can you see what is being done?

Comparing books.rw with your borrower_loans report

1. Scroll down to the borrower_loans report you created in the previous exercise.
2. Use the Utilities option, then the Archive option to generate a file called loans.rw
3. Compare loans.rw with books.rw. Can you explain how the Report writer code handles the use of User Prompts? Can you see any restriction on how it deals with Multi-tables?

Continue with this trainer