How to format reports using Microsoft PowerPoint
PTReportGen is a template-based reporting tool that retrieves data from database and fills Microsoft ® PowerPoint ® report with them.
Creating a report template directly in Micosoft PowerPoint
To make a report using PTReportGen, you should create a report template first. This report template is a Microsoft PowerPoint presentation that defines the layouts, formats and styles of the report. How to create a new presentation, refer to Microsoft PowerPoint Help.
Creating a template for a table report
To create a table report, you need to create a table in the report template file according to the report. The format of the table is the same as the format in the report. The report template is a blank report. PTReportGen will execute a SQL statement, retrieve data from database, and fill them into the report.
For a fixed table report, the format of the table is the same as the format in the report, you reserve same rows/columns in the report template as in the report. For a variable table report, you need to reserve some rows/columns in the report template. PTReportGen will automatically add some rows/columns according to the records.
If you want to display the data value in a custom format, you can write formatting expressions into data cells in the report template file. PTReportGen will get the text of the cell as a format expression before it puts a value into a cell, and output the value using the format expression.
Creating a template for a chart
Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data. You can create a chart in a slide using Microsoft Graph. PTReportGen supports charts created by using Microsoft Graph.
To create a chart, you need to add a chart in the report template file. The chart will be brought into the report file with the same chart type, display option, data format, label format and other chart item. The report template is a blank chart. PTReportGen will execute a SQL statement, retrieve data from database, and fill them into the datasheet of the chart.
Formatting a report template
PTReportGen supports ALL formatting features within native Microsoft PowerPoint, such as text formatting, tables, charts, pictures and graphics, drawing, headers and footers, preview and printing, VBA, macros, and more.
To make text stand out, you can format the text in selected characters. You can change the font, color, size of text, bold and italic formats.
You can align, center or justify a paragraph, change indent and tab settings, and change the line spacing of a paragraph.
Bulleted and numbered lists in Microsoft PowerPoint are easy to create. You can quickly add bullets or numbers to existing lines of text, or Microsoft PowerPoint can automatically create lists as you type.
Microsoft PowerPoint, by default, automatically formats certain types of text as you type. Automatic paragraph formatting includes automatic bulleted and numbered lists and resizing of text in text placeholders if the text doesn't fit at its current font size.
Layout refers to the way things are arranged on a slide. A layout contains placeholders, which in turn hold text such as titles and bulleted lists and slide content such as tables, charts, pictures, shapes, and clip art. Each time you add a new slide, you can choose a layout for it. You can also choose a blank layout.
Outputing a report to another file format
PTReportGen is a converter too. You can convert Microsoft PowerPoint presentations to and from other formats, such as HTML, XML, RTF, text, and Works. To output a report to another file format, you must specify the file type of the report in the PTR file.
PTReportGen supports all file formats that Microsoft PowerPoint supports. The supported file formats include:
Copyright © 2004 - 2014 LJZsoft Corporation. All rights reserved.