LEADER 09647oam 22005893 450 001 9910970844203321 005 20251116142416.0 010 $a1-930919-26-3 010 $a9786610544172 035 $a(CKB)111035898514184 035 $a(CtWfDGI)bks00002060 035 $a(MiAaPQ)EBC3301803 035 $a(BIP)7772421 035 $a(EXLCZ)99111035898514184 100 $a20210907d2002 uy 0 101 0 $aeng 135 $aurzn|||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aVisual FoxPro Report Writer $ePushing It to the Limit and Beyond 210 1$aMilwaukee :$cHentzenwerke Publishing, Inc.,$d2002. 210 4$dİ2002. 215 $a1 online resource (298 pages) 300 $aTitle from title screen. 300 $aIncludes link to companion web site. 300 $aIncludes index. 311 08$a1-930919-25-5 327 $aIntro -- 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. 327 $aLabels -- 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. 327 $aEvaluating 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?. 327 $aHow 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. 330 $aReports are key to a successful software application. It doesnt matter how efficiently the users can enter data, how much information the system can store or how many complicated calculations the system can process if theres no way to see the final outcome. In The Visual FoxPro Report Writer, Cathy Pountney tells you how to use every nook and cranny of the report writer, and even shows you how to do things you thought were up to now impossible. If youre serious about quality output from your VFP applications, you cant do without this book 606 $aApplication software$xDevelopment 606 $aDatabase management$xComputer programs 606 $aBusiness report writing$xComputer programs 606 $aDatabase management 608 $aElectronic books.$2lcsh 615 0$aApplication software$xDevelopment. 615 0$aDatabase management$xComputer programs. 615 0$aBusiness report writing$xComputer programs. 615 0$aDatabase management. 676 $a651.7/8/028557585 700 $aPountney$b Cathy$01865868 712 02$aBooks24x7, Inc. 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910970844203321 996 $aVisual FoxPro Report Writer$94473089 997 $aUNINA