| |
| |
Preface | |
| |
| |
Introduction | |
| |
| |
| |
Basic Impromptu Reporting | |
| |
| |
| |
So, You Just Bought Impromptu ... Now What? | |
| |
| |
What Is Impromptu? | |
| |
| |
What Kinds of Reports Are Available in Impromptu? | |
| |
| |
Standard or Managed Reporting | |
| |
| |
Ad-Hoc Reporting | |
| |
| |
Who Uses Impromptu? | |
| |
| |
Administrator | |
| |
| |
Report Developer | |
| |
| |
Report Consumer | |
| |
| |
Where Can Each Role Find Information? | |
| |
| |
So, Who Should Do What? | |
| |
| |
How Do I Load Impromptu? | |
| |
| |
Loading Impromptu | |
| |
| |
What Gets Loaded? | |
| |
| |
Create Desktop Shortcut | |
| |
| |
Differences with Administrator Version | |
| |
| |
Additional Products and Services | |
| |
| |
Summary | |
| |
| |
| |
Getting Started | |
| |
| |
Opening Your First Report | |
| |
| |
Start Impromptu | |
| |
| |
What Just Happened? | |
| |
| |
How This Affects the Report Developer/Consumer | |
| |
| |
Looking at the Report | |
| |
| |
Query Data | |
| |
| |
The Catalog | |
| |
| |
The Catalog Components | |
| |
| |
Questions and Answers | |
| |
| |
Summary | |
| |
| |
| |
Of Desktops, Menus, and Toolbars | |
| |
| |
Before We Begin | |
| |
| |
The Impromptu User Interface | |
| |
| |
Desktop | |
| |
| |
Menu | |
| |
| |
Toolbars | |
| |
| |
The Status Bar | |
| |
| |
The Two Parts of a Report | |
| |
| |
The Query | |
| |
| |
The Layout | |
| |
| |
Summary | |
| |
| |
| |
Creating New Reports | |
| |
| |
Creating a New Report | |
| |
| |
A Word about Templates | |
| |
| |
Let's Create a Report | |
| |
| |
Before We Run the Report... | |
| |
| |
Running the Report | |
| |
| |
Viewing the Report | |
| |
| |
Saving the Report | |
| |
| |
What Was Just Saved? | |
| |
| |
Saving Exercises | |
| |
| |
Summary | |
| |
| |
| |
Formatting a Report | |
| |
| |
Before We Begin | |
| |
| |
Different Ways to Format a Report | |
| |
| |
Using the Toolbar | |
| |
| |
Right Click Approach | |
| |
| |
Format Menu Approach | |
| |
| |
Formatting Strategies | |
| |
| |
Basics on Headers | |
| |
| |
Report Page Header | |
| |
| |
Column Headers | |
| |
| |
Summary | |
| |
| |
| |
Fundamental Reporting Concepts | |
| |
| |
| |
Filtering | |
| |
| |
Before We Begin | |
| |
| |
Filtering Reports | |
| |
| |
The Basics of Filtering | |
| |
| |
Multiple Filters | |
| |
| |
Dropdown Filtering | |
| |
| |
Filters in the QDB | |
| |
| |
Looking Around in the Filter Tab | |
| |
| |
Creating a Filter in the QDB Filter Tab | |
| |
| |
Changing Filters | |
| |
| |
Summary | |
| |
| |
| |
Calculations and Functions | |
| |
| |
Before We Begin | |
| |
| |
Basic Calculations | |
| |
| |
First: A Basic Calculation | |
| |
| |
Complex Calculations | |
| |
| |
A Calculated Column without a Calculation | |
| |
| |
Finally, Calculations for Strings | |
| |
| |
Functions | |
| |
| |
First, A Basic Function | |
| |
| |
Applying a Function to an Existing Calculated Column | |
| |
| |
Multiple and Nesting Functions | |
| |
| |
Other Uses | |
| |
| |
Summary | |
| |
| |
| |
Sorting and Grouping | |
| |
| |
Before We Begin | |
| |
| |
Sorting | |
| |
| |
Point and Click Sorting | |
| |
| |
Sorting in the QDB | |
| |
| |
Grouping | |
| |
| |
Point and Click Grouping | |
| |
| |
Grouping with the QDB | |
| |
| |
Associations | |
| |
| |
Be Careful! | |
| |
| |
Summary | |
| |
| |
| |
Totals and Summaries | |
| |
| |
Totals and Summaries and Reporting | |
| |
| |
Before We Begin | |
| |
| |
Point, Click, and Total | |
| |
| |
Where is the Total? | |
| |
| |
Totals in the QDB | |
| |
| |
How It Looks in the QDB... | |
| |
| |
Let's Do Another One | |
| |
| |
Smart Summaries | |
| |
| |
A Final Word on Associations | |
| |
| |
Other Ways of Adding Totals | |
| |
| |
Create a Total Using Insert. Calculation | |
| |
| |
Creating a Total Using the QDB | |
| |
| |
Summaries: More Than Just Totals | |
| |
| |
A Complete Totals Report from Scratch | |
| |
| |
Summary | |
| |
| |
| |
Advanced Topics | |
| |
| |
| |
Prompt Reporting | |
| |
| |
First, Let's See a Finished One | |
| |
| |
Under the Hood of the Prompt | |
| |
| |
Building a Basic Prompt Report | |
| |
| |
Prompt Manager | |
| |
| |
Adding Another Prompt and Filter | |
| |
| |
Debugging a Broken Prompt Report... | |
| |
| |
Error-Free Prompt Reports | |
| |
| |
Different Types of Prompts | |
| |
| |
Type-In Prompts | |
| |
| |
File Picklist Prompt | |
| |
| |
Prompts in the Catalog | |
| |
| |
Prompts in Complex Reports | |
| |
| |
One More Prompt Tip... | |
| |
| |
Summary | |
| |
| |
| |
Advanced Layouts and Frames | |
| |
| |
A General Description of Frames | |
| |
| |
Frames and Simple List Reports | |
| |
| |
Selecting a Parent Frame | |
| |
| |
The Report Body | |
| |
| |
Select Another Detail Level Cell... | |
| |
| |
Open an Advanced Layout | |
| |
| |
Common Frame Properties and Formats | |
| |
| |
Frame Properties | |
| |
| |
Frame Format | |
| |
| |
Specific Frames | |
| |
| |
Text Frames | |
| |
| |
Picture Frames | |
| |
| |
Chart Frames | |
| |
| |
List Frames | |
| |
| |
Form Frames | |
| |
| |
More Objects | |
| |
| |
Another Example: The Mailing List | |
| |
| |
Summary | |
| |
| |
| |
Drill Through Reporting | |
| |
| |
Drill Through Evolution | |
| |
| |
How Drill Through Works | |
| |
| |
What Was My Drill Through Filter? | |
| |
| |
Not Too Bad, Let's Do Another! | |
| |
| |
Filter on a Different Column | |
| |
| |
Only One Column per Drill Through? | |
| |
| |
How It's Done | |
| |
| |
View an Existing Drill Through | |
| |
| |
Create a Drill Through | |
| |
| |
Test New Drill Through | |
| |
| |
Summary | |
| |
| |
| |
Crosstab Reports | |
| |
| |
Crosstabs: The Basics | |
| |
| |
When to Use a Crosstab Report? | |
| |
| |
Opening an Existing Crosstab | |
| |
| |
Open The Report | |
| |
| |
Overview of Result Layout | |
| |
| |
Inside the QDB | |
| |
| |
Creating a Crosstab | |
| |
| |
Enhance a Basic Crosstab | |
| |
| |
Summarizing the Crosstab Report | |
| |
| |
Moving Items around in the Crosstab | |
| |
| |
Convert a List Report to a Crosstab | |
| |
| |
Building the List Report | |
| |
| |
Show the Report to the Boss | |
| |
| |
Convert to a Crosstab Report | |
| |
| |
Advanced Calculations | |
| |
| |
Calculate Button | |
| |
| |
Advanced Calculations | |
| |
| |
Summary | |
| |
| |
| |
Sub Reports | |
| |
| |
A Sub Report Is... | |
| |
| |
When to Use a Sub Report? | |
| |
| |
Opening an Existing Sub Report | |
| |
| |
Building a Sub Report | |
| |
| |
Get Started: The Requirements | |
| |
| |
Did You Really Need... | |
| |
| |
Not Just Linked Together | |
| |
| |
Summary | |
| |
| |
Index | |