PTReportGen

PTReportCom Introduction

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

Overview

PTReportCom is a solution for Microsoft ® PowerPoint ® 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 PTReportCom into their applications.

PTReportCom 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 PowerPoint presentation that defines the layouts and formats of a report. PTReportCom retrieves data from data source and fills data into PowerPoint presentation.

PTReportCom.dll

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

1. Create a template

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

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

    Set ptrpt = New PTReport
    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
    ptrpt.VarTableReport Recordset:=rec, Slide:=pptSlide, _
	    Table:=1, CellList:="A2", Reserve:=2, PageBreak:="12"
    rec.Close

PPTReport.exe

PPTReport.exe is an executable program that developed using PTReportCom.dll. It likes PTReportGen command line and can read a PTR file to create an PowerPoint report. To create a report using PPTReport.exe,

1. Create a template

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

2. Create a PTR file

Create a PTR file using PTReportGen or a text editor. The PTR file is a text file with a .ptr extension. It tells PTReportCom how to get data from data sources and how to put data into a report. Using the PTR file, it will simplify your development.

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

pptreport c:\report\custlist.ptr

Software Requirements

Microsoft Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista or later.
Microsoft Office 2000, Office XP, Office 2003 or later.