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