Creating Database Reports

1
Creating Database Reports

• Chapter 7
• Lesson A

2
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

3
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

4
Sample Matrix Report
5
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

6
Paper Design Window
7
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.

8
Reports Builder Object Navigator
9
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

10
Viewing a Report as a Web Page
11
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

12
Example Grouped Report
13
Creating Groups/Levels
14
Report Templates

• Custom templates store common formatting
  information such as
• Font
• Background color
• Graphics
• Stored in .tdf file
• Use Paper Layout Template Editor to edit

15
Paper Layout Template Editor
16
Applying Custom Templates to Reports

• Templates are applied to reports using Reports
  Wizard Template page
• Use Template file specification option button to
  select a custom template
• Or register template as a predefined template
• Modify the Developer user preferences file, so
  the custom template appears in the Predefined
  Templates list
• Copy the template file to the Reports Builder
  templates folder