WordReport.exe can be scheduled with Windows Scheduled Tasks or other tools. The process of generating reports can be fully automated, periodically or on events.
WDReportCom comes with a sample database, VB sample programs, VBA sample programs and sample reports. You can use them when learning the program. To use the samples, you must add a data source named "Report Sample" to specify the sample database.
To make a report template, you can use some sample data. It is very useful especially for formatting. After you have made the report template, you delete the sample data.
For a table report, you can format the value from data sources with a format expression. You should write a format expression into a data cell in the report template file first. WDReportCom will get the text of the cell as a format expression before it puts a value into a cell, and output the value using the format expression.
You can define the different formats and colors for positive values, negative values and zeros.
For a form report, you can format the value from data sources with the switch of a merge field or quote field like "\#" or "\@".
In the sample file "monthly_sales.doc", there is a macro called "CellRef". The macro can tell you the table number and the cell reference.
An irregular table does not have the same number of cells for each row or column. It does make it harder to process the document. In an irregular table, you have some difficulty to reference a cell, and an error may occur when you try to work with some rows or columns.
You can set the width of cells in the same column to be different, and keep the table have the same number of cells for each row. Select two or more cells in one row, merge them into one cell, and split the cell into two or more cells. You can drag the boundary and change the cell width.
To create a chart in the report template file, you can use some sample data. Using sample data, you can set the various chart options. After you have made the report template, you delete the sample data.
You can use (formula) fields to perform calculations in a report template file.
WDReportCom is a converter too. Besides Microsoft Word document, you can generate a report in other file format such as HTML, XML, RTF, text, Works. You also can convert data from database to other file format.
You can protect the generated report so that it can not be modified.
You can edit a WRF file (.wrf) with a text editor such as Notepad.
In a WRF file, for the report template file, report file and log file, it is possible to give a relative path. If it is a relative path, the base path is the path of the WRF file.
In a WRF file, you can use parameters in the SQL statements. To use parameters, you must define them first.
In a WRF file, you can use parameters in the paths and names of the report file, template file and log file. To use parameters, you must define them first.
You should be careful to define a unique name for each parameter, because WDReportCom will replace all strings that are the same as the names of the parameters. It is a good choice a name begins with the "$" character such as "$ReportDate".
If you get some errors when you run WordReport.exe, you can check the default log file "WordReport.log" under the WDReportCom program directory. If you do not define the log file in the WRF file, or can not create the log file defined, you can find log information in the WordReport.log.
In the [SQL] section in the WRF file, you can use comments. A comment is the "/*" characters, followed by any sequence of characters (including new lines), followed by the "*/" characters. You cannot nest comments.
To add totals or subtotals, you can use the aggregate functions in SQL statement.
To group data in a report, you should use GroupTableReport method, FormReport method or Group Table Report function, Form Report function.
In Group Table Report function or Form Report function in the WRF file, the order of groups should be in accordance with the order of ORDER BY clause in the SQL statement.
If you add a bookmark in a table, you can reference the table using the bookmark.
WDReportCom supports nested tables. You can reference a nested table by a table index like 2-1-2 or a bookmark.
In a HTML file, you can add a bookmark using the < a > tag. For example, The following example defines a bookmark named "salesreport".
< a name=salesreport > Sales Report< /a >
You can create reports with pictures using WDReportCom. You should store the path and name of the graphics file in the database, identify the image fields in the report function, and specify the inserted way, text wrapping style and size in the report template file.
If you insert pictures into the cells using table report function, you can adjust the position of the pictures by changing the cell margins.
To convert from pixels to points, it is depend on the screen resolution (DPI). If you have a 96 dpi screen (Windows PC), 4 pixels are equal to 3 points.
SetDocVariable method and DocVariable function support headers and footers. You can use it to put data into headers or footers.
It is very useful to create a temporary table. You can prepare data using INSERT/UPDATE/DELETE/INSERT SELECT, and then make a report using REPORT function.
You can write a program to make a WRF file using C, perl or DOS shell, and then run WordReport.exe to generate report. The two steps can be written into a batch file.
It will take more time using COPYRANGE argument than using RANGE argument. Fixed table report is slower than non-group variable table report with RANGE argument, and faster than non-group variable table report with COPYRANGE argument. In general, group variable table report is slower than non-group variable table report. But if the ranges of all groups and details are same and you do not use COPYRANGE argument, it is faster.
VarTableReport, GroupTableReport, FormReport methods will use clipboard. You can not copy and paste during report generating.