| Chapter 2 Installation and Startup |
Microsoft Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista or later.
Microsoft Office 97/98, Office 2000, Office XP, Office 2003 or later.
Run the installation program, and follow the instructions to complete XLReportGen installation.
If you don't have Microsoft Office installed, please install it first.
If your environment is Windows 95/98 and Office 97, and you don't have VB6.0 run-time files installed, please install it. For Windows 2000, Windows XP, Windows 2003 and Office 2000 or later, you do not need to install VB6.0 run-time files because they are included in OS and Office. To install VB6.0 run-time files, just run vbrun60sp5.exe, and follow the instructions.
If you don't have ODBC Driver for the database you want to access installed, please install it.
If your OS is Windows 95/98 and you don't have Microsoft Data Access Components 2.0 (MDAC_TYP) or later installed, please install it. For Windows 2000, Windows XP and Windows 2003, you do not need to install MDAC_TYP because it is preinstalled in OS. To install MDAC_TYP, just run mdac_typ.exe, and follow the instructions.
1. Quit XLReportGen.
2. Double-click the Add/Remove Programs icon in the Windows Control Panel.
3. Do one of the following:
4. Follow the instructions on the screen to complete uninstalling the program.
XLReportGen can be run in Windows mode or command line mode. The Syntax of command is:
excelreport < xrf file name > [-C] [-D] [-I interval] [-U1 user1] [-P1 pwd1] ... [-U10 user10] [-P10 pwd10] [pa1 pa2 ... pa10]
| xrf file name | Specifying an XRF (.xrf) file that tells XLReportGen how to get data from data sources and how to put data into a report. |
|
| -C | Running in command line mode. |
|
| -D | Display the generated report with Microsoft Excel. |
|
| -I interval | Log the processing records message. If interval is greater than 1, it is the interval of records. If interval is less than 1, it is the percent of interval. |
|
| -U1 user1 ... -U10 user10 |
Specify the user names. user1 is the user name of the first data source. user2 is the user name of the second data source...... |
|
| -P1 pwd1 ... -P10 pwd10 |
Specify the passwords. pwd1 is the password of the first data source. pwd2 is the password of the second data source...... |
|
| pa1 ... pa10 | The values of the parameters defined in the XRF file. You can use parameters in SQL statements. XLReportGen will replace the names of parameters in a SQL statement with the actual values before it executes a SQL statement. You can use no more than 10 parameters in one report. |
For example, you have defined two parameters in your XRF file. The first parameter is sales date, and the second is the category of the products. You can run XLReportGen in command line mode as follows:
excelreport c:\excelreport\myreport.xrf -c 1996-05-01 "Dairy Products"