|Chapter 1 Introduction|
PTReportGen is a report generator for Microsoft PowerPoint that outputs reports in Microsoft PowerPoint format. If you know how to use Microsoft PowerPoint and write SQL statements, you can use PTReportGen to create all kinds of reports as you need.
To create a report, PTReportGen need to read a report template file and a PTR file. The report template file is a Microsoft PowerPoint presentation that defines the layouts and formats of a report. The PTR file contains SQL statements and some information, and tells PTReportGen how to get data from database and how to put data into a report. First PTReportGen creates a blank report using the report template file, executes SQL statements in the PTR file, and puts the data from database into the report.
PTReportGen includes the following features:
Just use Microsoft PowerPoint as your reporting tool. You design reports like layouts, formats and styles directly using Microsoft PowerPoint. And you will get reports in Microsoft PowerPoint presentation format as a result.
The main advantage of using PTReportGen is based on the fact that all formatting is done directly in Microsoft PowerPoint. You can take full advantage of Microsoft PowerPoint including text formatting, tables, shapes, charts, pictures and graphics, drawing, headers and footers, and more.
Open XML is an open file format for the core document-oriented Office applications. It facilitates document creation and manipulation in server environments where you do not need to install the Office client applications.
PTReportGen executes SQL statements to extract data from database. Supports all type SQL: DML, DDL and DCL. Multiple SQL statements can be executed in one report building process. You can perform queries on databases, insert data into databases, and create database objects like tables. The power of SQL can be harnessed for maximum efficiency in reporting.
You know how to use Microsoft PowerPoint and how to write SQL, it is enough. It does not require programming to create reports.
Using ADO.NET to connect to databases, PTReportGen is independent of database systems. It can access to almost all of databases such as Oracle, DB2, Sybase, Informix, Microsoft SQL Server, Teradata, MySQL, Microsoft Access and dBase through OLE DB and ODBC.
PTReportGen supports multi-databases in one report. You can get data from some different databases such as Oracle, DB2 and Microsoft SQL Server, and put these data into one report.
PTReportGen enables you to create reports with parameters. You may use parameters in SQL statements. You will be asked to input the values of parameters while creating reports.
PTReportGen supports command line mode. So it is possible to call PTReportGen from other program. For developers, you can integrate PTReportGen into your application.
You can create complex reports. The complexity might come from report formatting as well as report content.
PTReportGen enables you to include sophisticated, colorful charts in your reports. You can use charts any time you want to improve the usefulness of a report.
PTReportGen can insert pictures from the graphics files, and change the size of pictures.
One Microsoft PowerPoint presentation may contain many reports. One report may be one or more slides. You can generate a presentation in one generating process.
The process of report generation can be fully automated, periodically or on events. PTReportGen can be scheduled with Windows Scheduled Tasks or other tools.
With on time configuration, you can repeatedly generate reports especially periodic reports such as daily, weekly, monthly and annual reports.
PTReportGen can be run on your desktop or server.