User manual LJZSOFT WDREPORTGEN

[. . . ] WDReportGen User Manual Version 3. 7 2007-11 Copyright© 2003 -2007 LJZsoft Corporation All rights reserved Contents CHAPTER 1 INTRODUCTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1. 1 OVERVIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1. 2 FEATURES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 CHAPTER 2 INSTALLATION AND STARTUP. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 2. 1 SOFTWARE REQUIREMENTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 2. 2 INSTALLING WDREPORTGEN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 2. 3 UNINSTALLING WDREPORTGEN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 2. 4 COMMAND LINE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 CHAPTER 3 QUICK START . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 3. 1 LEARNING HOW TO USE WDREPORT GEN. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 3. 2 SAMPLE DATABASE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 3. 3 STEPS OF REPORTING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 3. 4 MY FIRST REPORT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 3. 4. 1 Creating a report template. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 3. 4. 2 Creating a WRF file. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 3. 4. 3 Configuring the report. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ] You must add total first using a Fixed Table report functio n before you use the Variable Table report function. Because the cell address of the total field will change after you use Variable Table report function. For more information, refer to the samples invoice. wrf and sales_detail. wrf within WDReportGen. 5. 9 Pictures 5. 9. 1 Inserting pictures into a report template To make eye-catching reports, you can add pictures to your reports. You can insert pictures into the report template directly in Microsoft Word . For example, you want to display a logo in your report. You can insert the logo graphics file into the report template. For more information about adding pictures to documents , refer to Microsoft Word Help. 5. 9. 2 Inserting pictures into a report Except for inserting the static pictures during report design, you want to insert pictures during report buliding process. You hope a reporting tool to pull pictures from database into Word report. WDReportGen can insert pictures from the graphics files, and support all graphics file format that Microsoft Word support. To insert pictures into a report using WDReportGen, you should do as follows: 1. Store the path and name of the graphics files in the database You stored the path and file name of the pictures in database, did not store the pictures. The file path can be a relative path, an absolute path or a URL. For - 49 - example, you store "images \emp1. jpg" in Photo field. Identify the image fields in the report function Write a report function in the WRF file, and identify the image fields using IMAGE argument. Specify the inserted way, text wrapping style and size in the report template To specify the inserted way, text wrapping style and size, you should write a formatting expression in the report template file. For a table report , you write a formatting expression in the cell. For a form report, write a formatting expression in the field switch "\#". WDReportGen will get the formatting expression, and insert a picture into the report according to the instruction in the format expression. Run WDReportGen to generate report with pictures During report generating process, WDReportGen will read the graphics files, and insert them into the report according to your instruction. If the path and file name of the picture is ", WDReportGen will return ". WDReportGen will return " " " #Error"if it does not find the file of the picture. For more detail information about pictures, refer to the samples employee_profile. wrf, product_catalog. wrf within WDReportGen. 5. 10 Using Parameters To use a parameter, you must define it first. [. . . ] Display the quarter of the year as a number (1 ­ 4). - 106 - y yy yyyy h Hh N Nn S Ss ttttt Display the day of the year as a number (1 ­ 366). Display the year as a 2 -digit number (00 ­ 99). Display the year as a 4 -digit number (100 ­ 9999). Display the hour as a number without leading zeros (0 ­23). [. . . ]