Ljzsoft PPTREPORT User Manual

PPTReport

Looking for a powerful and flexible reporting tool that’s easy to use, cost
effective and extract data from any database? Microsoft Office is your choice.
With the help of PPTReport, Microsoft PowerPoint is a powerful and flexible
reporting tool.
PPTReport 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 PPTReport to create all kinds of
reports as you need.

Benefit

n Use Microsoft PowerPoint as your reporting tool
You have installed Microsoft Office in your computer, and you almost use
Microsoft Office every day. You are familiar with Microsoft PowerPoint, and
already know how to use it. Use Microsoft PowerPoint as reporting tool, it is
very convenient.
n Easy to use
You already know how to use Microsoft PowerPoint. It is easy. Get data using
SQL. It is simple. You can create reports without programming experience.
Easy to learn, use and maintain.
n Powerful and flexible
PPTReport is powerful and flexible because Microsoft PowerPoint and SQL
are powerful and flexible. You can create extremely complex reports.
n Saves money
You do not need to buy extra costly reporting tools. No training is necessary
because everyone uses Microsoft Office.
n Saves time

- 1 -

Reduce development time and training time.
n Improves productivity
More productive when reports are in familiar formats like Microsoft PowerPoint.
n For various users
For IT users, you know Microsoft PowerPoint and SQL, it is enough. No
programming is required. For business users, you can create report templates
using Microsoft PowerPoint. PPTReport enables you to design reports like
defining the layout, style, format of reports. For developers, PPTReport can be
called by your program. It enables you to integrate Microsoft PowerPoint into
your application.

Overview

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

Report

Template

PTReportGen

Report

template file is a Microsoft
PowerPoint presentation that

SQL

defines the layouts and formats
of a report. The PTR file contains

Database

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, and then executes SQL statements in the PTR file to get
data from database, and fills data into the report to generate the desired report

- 2 -

in Microsoft PowerPoint format.

Feature

PTReportGen includes the following features:
n Using Microsoft PowerPoint as your reporting tool
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.
n Making report template directly using Microsoft PowerPoint
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, charts,
pictures and graphics, drawing, headers and footers, preview and printing,
VBA, macros, and more.
n Accessing to databases using SQL
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.
n Creating reports without programming experience
You know how to use Microsoft PowerPoint and how to write SQL, it is enough.
It does not require programming to create reports.
n Connection to all databases using ODBC
PTReportGen connects to databases using ODBC. Access to all databases
which support ODBC such as Oracle, DB2, Sybase, Informix, Microsoft SQL
Server, Teradata, MySQL, Microsoft Access, dBase.
n Supporting multi-databases in one report

- 3 -

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.
n Generating reports with parameters
PTReportGen gives you an opportunity to create reports with parameters. You
may use parameters in SQL statements. You will be asked to input the values
of parameters while generating reports.
n Supporting Windows mode and command line mode
PTReportGen supports command line mode. So it is possible to call
PTReportGen from other program. For developers, you can integrate
PTReportGen into your application.
n Creating complex reports
You can create complex reports. The complexity might come from report
formatting as well as report content.
n Creating reports with charts
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.
n Creating reports with pictures
PTReportGen can insert pictures from the graphics files, and set the inserted
way, text wrapping style and size of the pictures according to your instruction.
n Many reports in one Microsoft PowerPoint presentation
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.
n Conversion of file formats
PTReportGen is a converter too. You can convert PowerPoint presentation to
and from other formats, such as HTML, RTF, GIF, JPG and BMP. You also can
convert data from database to other file format.
n Generating reports automatically

- 4 -

The process of report generation can be fully automated, periodically or on
events. PTReportGen can be scheduled with Windows Scheduled Tasks or
other tools.
n One time configuration
With on time configuration, you can repeatedly generate reports especially
periodic reports such as daily, weekly, monthly and annual reports.
n Flexible deployment
PTReportGen can be run on your desktop or server.

Reporting steps

PPTReport is simple and easy to use. It does not require programming to
create reports. It is enough if you know how to use Microsoft PowerPoint and
write SQL statements. Developing a report with PPTReport requires only three
steps:
Step 1. Create a report template file using Microsoft PowerPoint, define the
layouts, styles, formats of reports.
For example, to create a Customer List report, you make a report template as
follows.

Step 2. Create a PTR file with a .ptr extension using PPTReport. The PTR file
tell PPTReport how to extract data from database, and where and how to put
data.
For example, you create a PTR file, and write a report function and SQL as
follows.

- 5 -

/* Customer List */
@F1=Report(slide=2 type=var cell=A2 pagebreak=19 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 PPTReport to generate a report in Microsoft PowerPoint
presentation.

The report Customer List is generated as follows.

- 6 -

System requirement

n Microsoft Windows 95, Windows 98, Windows NT, Windows 2000,

Windows XP, Windows 2003 or later.

n Microsoft Office 2000, Office XP, Office 2003 or later.

PTReportGen Copyright © 2006 LJZsoft Corporation. All Rights Reserved.

Contact/Support

Email: [e-mail]

[e-mail]

[e-mail]

WWW: http://www.ljzsoft.com

- 7 -