Microsoft Word Reporting Tool
 

How to output report to Microsoft Word

WDReportGen is simple and easy to use. It does not require programming to create reports. It is enough if you know how to use Microsoft ® Word ® and write SQL statements. To output a report using WDReportGen, it requires only three steps:

Step 1

Create a report template file using Microsoft Word, define the layouts, styles, formats of reports.

For example, to create a Customer List report, you make a report template as follows.

make a word report template using microsoft word

Step 2

Create a WRF file with a .wrf extension using WDReportGen. The WRF file tell WDReportGen how to extract data from database, and where and how to put data.

For example, you create a WRF file, and write a report function and SQL as follows.

/* Customer List */
@F1=Report(table=1 type=var cell=A2 reserve=2)
SELECT CompanyName
,CityName
,CountryName
,ContactName
FROM Customers, Cities, Countries
WHERE Customers.CityCode = Cities.CityCode
AND Customers.CountryCode = Cities.CountryCode
AND Customers.CountryCode = Countries.CountryCode
ORDER BY CompanyName,CityName,CountryName
;

Step 3

Run WDReportGen to generate a report in Microsoft Word document.

output report to word using WDReportGen

The report Customer List is generated as follows.

word report generated by WDReportGen

Word Report Introduction Download WDReportGen Introduction PDF (124KB)


 


Copyright © 2004 - 2014 LJZsoft Corporation. All rights reserved.