Databases Reference
In-Depth Information
2.
In the wizard, choose to create a Classic Report.
Name this report "
My Mini Book catalog
" and the region title as "
Browse our
books
".
3.
4.
In the SQL Query section of the report, write the following SQL:
SELECT "BOOKID",
"BOOKTITLE","BOOKISBN","BOOKPUBLISHER","BOOKEDITION","BOOKCATEGORY","BOOKDESCRIPTION","BOOKPRI
CE","AUTHOR", dbms_lob.getlength("BOOKIMAGE") "BOOKIMAGE" FROM Books
5.
Complete the wizard to create the report. After you have done so, edit the
report again. You should have the screen shown in Figure 10-14.
Figure 10-14.
Changing the SQL for the region source
6.
Complete the rest of the wizard using the default settings.
