Franklin

Visual FoxPro Report Writer : Pushing It to the Limit and Beyond.

Author/Creator:
Pountney, Cathy.
Publication:
Milwaukee : Hentzenwerke Publishing, Inc., 2002.
Format/Description:
Book
1 online resource (298 pages)
Status/Location:
Loading...

Options
Location Notes Your Loan Policy

Details

Subjects:
Visual FoxPro for Windows.
Application software -- Development.
Database management -- Computer programs.
Business report writing -- Computer programs.
Database management.
Form/Genre:
Electronic books.
Contents:
Intro
Dedication
Our Contract with You, The Reader
Table of Contents
Acknowledgements
About the Author
How to Download the Files
Chapter 1 Introduction
Overview of chapters
Wizards
The Report Designer
The "after life"
The Label Designer
The "other world"
Parts of a report
General information
Toolbars
Enjoy!
Chapter 2 The Report Wizard
Starting the Report Wizard
Creating a single-file report
Selecting fields
Finishing the report
The rest of the Report Wizard
Step 2-Group Records
Step 3-Choose Report Style
Step 4-Define Report Layout
Step 5-Sort Records
Step 6-Finish
The final word
The One-to-Many Report Wizard
Conclusion
Chapter 3 Learning the Basics
Invoking the Report Designer via the Menu
Invoking the Report Designer via the Command Window
Create a blank report
Modify an existing report
Create a Quick Report
Setting up the page
Columns
Print area
Print order
Left margin
Print Setup
The Report Designer environment
Grid Lines
Snap to Grid
Set Grid Scale
Show Position
Report bands
Adding and removing bands
Title and Summary bands
Group Header and Footer bands
Column Header and Footer bands
Changing the height of a band
On Entry and On Exit
Running the report
Wrapping up
Chapter 4 The Data Source
Normalized vs. Denormalized
Normalized data
Denormalized data
Which is better?
Private Data Session
The Data Environment
The Data Environment window
The Properties window
Mind boggling
Real-world Data Environment issues
Table of Contents
Where's the data?
May I take your order, please?
Don't you dare open that table
A fly on the wall
The FoxPro 2.x Environment
Use your imagination
Chapter 5 Report Objects
Types of controls.
Labels
Fields
Shapes
Pictures and ActiveX Bound controls
Using the Report Controls toolbar
Select Objects
Label
Field
Line
Rectangle
Rounded Rectangle
Picture/ActiveX Bound controls
Button Lock
Common options
Field/Object position
Float and Stretch with overflow
Print When
Stretch Downwards
Comment
Manipulating the controls
Selecting controls
Moving controls
Resizing controls
Duplicating controls
Deleting controls
Changing properties
Editing a Label object
More ways to add controls
Insert Control
The Data Environment
Quick Report
Conclusion
Chapter 6 Adding Pizzazz to the Objects
Layout
Align
Size
Horizontal spacing
Vertical spacing
Z-order
Group/Ungroup
Appearance
Font
Default Font
Color
Text Alignment
Reading Order
Fill
Pen
Mode
Programming is an art
Chapter 7 Data Grouping
Sorting it all out
Use an existing index
Create a temporary index
Use SQL to create a temporary cursor
Your choice
Creating a Data Group
Group expressions
Group properties
Group Header and Footer bands
Nesting Data Groups
Adding more Data Groups
Deleting Data Groups
Moving Data Groups
How Nested Data Groups are processed
Cool tricks with Data Groups
Dynamic Data Groups
A group of one
Fudging another Summary band
Maintaining a fixed location
Creating white space with Data Groups
There's power in groups
Chapter 8 Report Variables
Creating variables
Variable name
Insert and Delete
Value to store
Release after report
Using calculations
Calculate
Initial value
Reset at
Using Report Variables
Simple Report Variables
Conditional Report Variables
Counting Data Groups
Understanding the process
Order of Report Variables.
Evaluating a Report Variable
Resetting a Report Variable
Mission impossible
Chapter 9 Running Reports
Where did it go?
Preview on the screen
Print to a printer
Print to a file
Print to an ASCII file
Which records?
Scope
For <
expression>

While <
expression>

Miscellaneous clauses
Heading
Plain
Range
Summary
NoOptimize
NoWait
Name
Environment
Special preview issues
The Print Preview toolbar
Maximize the Print Preview window
Preview multiple reports at once
Seeing ghosts
Special printing issues
The Printing dialog
Chaining reports
Number of copies
Distribution
To be or not to be (excluded, that is)
Modifying reports within an application
Eliminating printer-specific information
Debugging
Invalid report
Nesting error
Variable not found
Run with it
Chapter 10 Solutions to Real-World Problems
Using Print When expressions
How do I know whether the user is previewing or printing?
How do I print ledger-style shading?
How do I simulate greenbar paper?
How do I keep a stretchable Group Footer together without wasting space all the time?
How do I prevent an orphaned Group Footer?
Using UDFs and Report Variables
How do I know if the user canceled?
How do I print "continued"?
How do I print subtotals in the Page Footer band at the end of each Data Group?
How do I print totals in the Page Footer band of only the last page?
Building the right cursor
How do I print multiple Detail bands?
How do I span a single record across multiple pages?
How do I print laser checks (stub/check/stub)?
Printing graphics
How do I print dynamic graphic images in FoxPro 2.x?
How do I print several detail lines to the right of one image?
How do I print Rich Text on a report?.
How do I print bar codes?
Miscellaneous
How do I print "Page x of y"?
How do I force a Data Group to start on an odd page?
How do I print vertical text?
How do I print check boxes, check marks, and so on?
How do I print captions from the database container?
How do I create a Report template?
How do I print preprinted forms?
How do I print from two different paper trays?
Conclusion
Chapter 11 Hacking the FRX
Where's the report?
Understanding the report table
The records
The unit of measure
The position
The fields
Let's start hacking!
Printer-specific information
Changing information at run time
Custom paper sizes
Watermarks
Leading
A certified hacker
Chapter 12 Labels
The first time
The Label Wizard
Step 1-Select Tables
Step 2-Choose Label Type
Step 3-Define Layout
Step 4-Sort Records
Step 5-Finish
The Label Designer
Invoking the Label Designer via the Menu
Invoking the Label Designer via the Command Window
Setting up the page
Special issues
Continuous labels
Sheet labels
Wrapping up
Chapter 13 Beyond the VFP Report Writer
Within Visual FoxPro
@…SAY
? and ?? commands
??? command
Freeware utilities
FRX2Word by John Koziol
Visual GenRepoX by Markus Egger
RAS PrintFRX by Rick Schummer
VBPrinter by John Koziol
Direct Print by Ed Rauh
wwPDF by Rick Strahl
Epson POS Demo by Mark McCasland
WinFax Demo by John Henn
Text Mode by Hilmar Zonneveld
Raw Print by Ramon F. Jaquez
Commercial Report Writers
Foxfire! Query and Report Writer
R&
R Report Writer
Crystal Reports
Virtual Print Engine
Other forms of output
PDF
Automation (Word and Excel)
The end!
Index.
Notes:
Description based on publisher supplied metadata and other sources.
Local notes:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Other format:
Print version: Pountney, Cathy Visual FoxPro Report Writer
ISBN:
9781930919266
9781930919259
OCLC:
70070212