XLReportGen

XLReportCom Introduction

XLReportCom is powerful and flexible reporting solution, and the most cost effective.

Overview

XLReportCom is a solution for Microsoft ® Excel ® reporting. It includes an ActiveX component and an executable file that can be used to develop your applications. Developers can save time and meet their users needs by integrating the report processing power of XLReportCom into their applications.

XLReportCom is a template-based solution. To create a report, you need to create a report template file first. The report template file is a Microsoft Excel workbook that defines the layouts and formats of a report. XLReportCom retrieves data from data source and fills data into Excel workbooks.

XLReportCom.dll

XLReportCom.dll is an ActiveX DLL that provides XLReport object. You can write a program to work with the object. To create a report using XLReport object,

1. Create a template

In Microsoft Excel, create a report template file. Static values and any Excel features included in the template will be included in the generated report.

2. Write the code in your application. For example,

    Set xlrpt = New XLReport
    Set con = New ADODB.Connection
    Set rec = New ADODB.Recordset
    con.ConnectionString = "Data Source=Report Sample"
    con.Open
    strSQL = "SELECT CompanyName, ContactName 
	    FROM Customers ORDER BY CompanyName"
    rec.Open strSQL, con
    xlrpt.VarTableReport Recordset:=rec, _
	    Worksheet:=xlWorksheet, CellList:="A3", Reserve:=2
    rec.Close

ExcelReport.exe

ExcelReport.exe is an executable program that developed using XLReportCom.dll. It likes XLReportGen command line and can read an XRF file to create an Excel report. To create a report using ExcelReport.exe,

1. Create a template

In Microsoft Excel, create a report template file. Static values and any Excel features included in the template will be included in the generated report.

2. Create an XRF file

Create an XRF file using XLReportGen or a text editor. The XRF file is a text file with an .xrf extension. It tells XLReportCom how to get data from data sources and how to put data into a report. Using the XRF file, it will simplify your development.

3. Run ExcelReport.exe to generate the report. For example,

excelreport c:\report\custlist.xrf

Software Requirements

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.