Default Report Writer Exercise

Objectives:

1. To explore the facilities provided by the Preview Report utility.
2. To produce output from the Library database in varying formats.
3. To determine the limitations of Preview Reports.

1. From the top level Ingres/Menu invoke the Reports utility.
2. Using the Preview facility, run three reports on the borrower table using the following options. In each case use the default destination. Note and compare the appearance of each report.
   1. Tabular style
   2. Wrap style
   3. Tabular style
   You can save each report using the File option. and obtain printouts that show each of the available styles.

   Note that:

   • tables with record length <80 characters will not demonstrate the Wrap style
   • the default style will change depending on the Table width.
3. Use the SQL command shown below to create a view (you will need to use the Queries/SQL utility to run the command).

   CREATE VIEW some_borrower_info AS
   SELECT
   	bor_no AS Number,
   	bor_name AS Name,
   	bor_state AS Status
   FROM  borrower;
   

4. Run a PREVIEW Report for your VIEW and produce printed output.

Continue with this trainer