HP 3000 Manuals HP 3000 Manuals
Table of Contents
HP ALLBASE/BRW Tutorial
HP ALLBASE/BRW Tutorial : COPYRIGHT NOTICE
Ch 1. Overview
What is BRW?
The BRW System
Flexible Data Access
Advanced Calculations and Functions
The Report Writer
Run-Time Report Execution
HP BRW-Desk
How the Tutorial is Structured
Quizzes
Time Needed
The Tutorial and the Reference Manual
BRW Training Course
Where is the Tutorial Data Located?
In Case of Difficulty
Ch 2. LESSON 1: Getting Started With BRW
The Tasks
What You Will Learn
Exercise 1:Learning about BRW Data
Exercise 2: Learning about Data Dictionaries
Exercise 3:Logging In and Running BRW
Exercise 4:Leaving BRW
Lesson 1: Quiz 1
Ch 3. LESSON 2: A Simple Report
The Tasks
What You Will Learn
Exercise 1:Sketching the 1st Report
Exercise 2:Using the Tutorial Glossary
What is a Break?
What is a Lineset?
Applying What You Learned
The Linesets for This Report
LESSON 2: Quiz 1
Exercise 3:Creating the Report
Where to Begin
Creating the Report
Help Screens
Exercise 4:Adding a Password and a Report Description
Exercise 5:Defining the Data Access
Defining a Table
Make Sure You Can Use All the Items
Lesson 2: Quiz 2
Exercise 6:Defining the Sorts and Breaks
Final Access Table Illustration
Lesson 2: Quiz 3
Exercise 7:Defining the Linesets
The Page Heading Lineset
Exercise 8:Using Standard Items
The Level 1 Break Heading Lineset
The Detail Lineset
Deleting Lines
The Level 1 Break Footing Lineset
The Report Footing Lineset
Lesson 2: Quiz 4
Exercise 9:Reviewing the Layout
Exercise 10:Compiling the Report
Exercise 11: Requesting the Report
Exercise 12: Reviewing the Report Online
Execution Statistics
Lesson 2: Quiz 5
Ch 4. LESSON 3: Refining Your Report
Before You Begin
The Tasks
What You Will Learn
The Data You Need
The Report Sketch
Exercise 1:Creating the Second Report
Exercise 2:Defining the Data Access
Defining the relation
Exercise 3:Defining Relation Conditions
Error Checking
Checking to see the items
Exercise 4:Relating Another Table
Items with Identical Names
Final Table (CUSTREP2-DATA)
Using Quick Browse
Defining an open join
LESSON 3: Quiz 1
Exercise 5:Define the Sorts and Breaks
LESSON 3: Quiz 2
Exercise 6:Defining the Linesets
The Page Heading Lineset
The Level 1 Break Heading Lineset
The Level 2 Break Heading Lineset
Substituting a line
Suppressing lines
The Detail Lineset
Copying lines
Using Layout Calculated Items
The Level 2 Break Footing Lineset
The Level 1 Break Footing Lineset
The Report Footing Lineset
LESSON 3: Quiz 3
Exercise 7:Reviewing the Layout
Exercise 8:Compiling The Report
Naming the Execution File
Exercise 9:Requesting The Report
Example Printouts
LESSON 3: Quiz 4
Ch 5. LESSON 4: Considering Performance
LESSON 4: Considering Performance
Before You Begin
The Tasks
Performance
What You Will Learn
The Report Data
Sketch the Report
The Linesets for This Report
Exercise 1:Adding and Describing the Third Report
Exercise 2:Defining the Data Access
Using More Than Two Source Tables
Using More Than Two Relations
Exercise 3:Understanding Keyed Access
Default Access
Tuned Access
LESSON 4: Quiz 1
Exercise 4:Defining the Selection Sets
Overview
What is a Parameter?
What is a Selection Set?
Selection Conditions and Relation Conditions
Your Task
Defining the Selection Set for Sales Managers
LESSON 4: Quiz 2
Exercise 5:Defining the Sort and Breaks
Absolute Positioning of Linesets
LESSON 4: Quiz 3
Exercise 6:Define the Linesets
Defining the Report Heading Lineset
Adding the Standard Items for REQUEST-DATAn
The Page Heading Lineset
Level 1 Break Heading and Level 2 Break Heading Linesets
The Detail Lineset
The Level 2 Break Footing Lineset
The Report Footing Lineset
LESSON 4: Quiz 4
Exercise 7:Reviewing the Layout
Exercise 8:Compiling the Report
Exercise 9:Request the Report
Example Printouts
Run (1)
Run (2)
Run (3)
Run (4)
Run (5)
LESSON 4: Quiz 5
Report Performance
Lesson 3 Compilation Listing
Lesson 3 Execution Statistics
Access Blocks and Workfiles
Access Structure
Performance Information
Default Access
Lesson 3 Execution Statistics Explanation
Specifying The Access Sequence and Method
Keyed Access
Lesson 4 Compilation Listing
Lesson 4 Execution Statistics
Lesson 4 Execution Statistics Explanation
Why Does the Third Report Execute Faster?
Performance Summary
LESSON 4: Quiz 6
Ap A. Answers to Quiz Questions
Lesson 1: Quiz 1
Lesson 2: Quiz 1
Lesson 2: Quiz 2
Lesson 2: Quiz 3
Lesson 2: Quiz 4
Lesson 2: Quiz 5
Lesson 3: Quiz 1
Lesson 3: Quiz 2
Lesson 3: Quiz 3
Lesson 3: Quiz 4
Lesson 4: Quiz 1
Lesson 4: Quiz 2
Lesson 4: Quiz 3
Lesson 4: Quiz 4
Lesson 4: Quiz 5
Lesson 4: Quiz 6
Ap B. Managing the BRW Tutorial
Managing the Tutorial
Who Should Read This Appendix?
Store the Tutorial Files
How the Tutorial is Set Up
Other Changes to Account ITF3000
Default User
Managing Multiple Users of the Tutorial
Managing Students' Files
Tutorial Files
Example Solutions
Specification Solutions
Execution Solutions
Printfile Solutions
BRWDIC File
Database TOYDB
Amending the TOYDB
GLOSSARY
INDEX
Index