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.
Description based on publisher supplied metadata and other sources.
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.