| |
| |
| 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 | |