creatingdatabasereports-EmunixEmich.ppt

Guide to Oracle 9i Creating Database Reports Chapter 7 Lesson A Objectives Understand Reports Builder report styles Use the Report Wizard to create a report Configure the appearance of a report View a report in a Web browser Create a master-detail report Create a custom template Apply a custom template to a report Introduction to Reports Builder Database Reports Reports Builder allows developers to distribute reports as: Web pages .pdf files Printed And other formats Layout styles include: Tabular Form Mailing Label Form Letter Matrix Sample Matrix Report Using the Report Wizard to Create a Report Basic steps using Report Wizard: Specify the data that the report displays Select the report style Configure the report properties and layout Paper Design Window Modifying the Report Appearance Use Reports Builder environment to modify the report appearance and customize the report features Paper design window shows how report appears on paper To view as web page preview paper design as web page Make sure form displays correct values before editing design Use the Paper Design window to change fonts, item sizes, etc. Reports Builder Object Navigator Viewing the Report as a Web Page To preview a report as a Web page: Click the Run Web Layout button on the Reports Builder toolbar Creates the Web page source code for the report Displays as Page Design view without any formatting changes To view formatting changes: preview the report using either a Paginated HTML or a Paginated HTMLCSS format Viewing a Report as a Web Page Creating a Master-Detail Report Report can display master-detail data SQL query must retrieve master and detail data Use Groups page to define master and detail groups Two report styles: Group left: master records appear on the left side of the report; detail records appear in columns to the right of the master records Group above: detail records appear below the master records Place column names in Levels on Available Columns page Example Grouped Report Cr