Reports

1. Reports • Report builder meets the challenge by making it easy to design, publish, and distribute • professional, production-quality reports in a variety of formats to meet any business need • A Developer/2000 report is made up of objects, the building blocks that define the • various parts of the report. Some objects, like fields, are visible in the report and others, like • queries, work behind the scenes. • Two models • data model: defines the data retrieved • layout model: defines the style of the report • Data model: • queries: Queries select the data from a standard data source such as Oracle, DB2 • using SQL SELECT or PL/SQL statements. • columns: represent the columns in the data source that are selected by the query. • Groups: organize the data into sets and hierarchies. By default, one group is created • for each query in the report. • Parameters: are variables, such as the printer name, to which users can assign values • when the report is run. • Data model links: are used to define a master/detail(parent-child) relationship between the • data of two queries.

2. Building a simple report • Step 1: use the report wizard: • Step 2: Choose the report style

3. Building a simple report contd. • Step 3: create a query • Step 4: Select table(s) and column(s) • Step 5: select the columns for display

4. Building a simple report contd. • Step 6: select summary fields (if any) • Step 7: choose a template

5. Building a simple report contd. • Step 8: Run the report • Step 9: Include date and page number