What's New in PHP Report Maker 5

Features

Detail and Summary Report

Also support summary only reports.

Crosstab Report

Flash and JavaScript (HTML 5) Charting

Supports multiple charts for each report (See Chart Setup). Configurable chart properties. Supported chart types:

• Column 2D Chart
• Column 3D Chart
• Pie 3D Chart
• Pie 2D Chart
• Line 2D Chart
• Bar 2D Chart
• Area 2D Chart
• Doughnut 2D Chart
• Funnel Chart
• Multi-series Column 2D Chart
• Multi-series Column 3D Chart
• Multi-series Line 2D Chart
• Multi-series Area 2D Chart
• Multi-series Bar 2D Chart
• Stacked Column 2D Chart
• Stacked Column 3D Chart
• Stacked Area 2D Chart
• Stacked Bar 2D Chart
• Multi-series Column 2D Dual Y Chart
• Multi-series Column 2D Dual Y Chart
• Candlestick Chart
• Gantt Chart
• Doughnut 3D Chart
• Multi-series Bar 3D Chart
• Stacked Bar 3D
• Bar 3D Chart
• Scroll charts

Note: PHP Report Maker ships with FusionCharts Free. Registered users of PHP Report Maker 5 are entitled to enjoy the benefit of the new FusionCharts extension with licensed FusionCharts v3 which is a paid product with a wider variety of chart types, a host of advanced features and the ability to render the charts in JavaScript as well. Read FusionCharts Free vs. FusionCharts for detailed comparison.

 

Advanced Chart Properties

View Formatting for Fields (See Field Setup)

Grouping Intervals (See Field Setup)
Support grouping intervals similar to Microsoft Access:

Detail and Summary Report			Crosstab Report
Numeric field	Text field	Datetime field	Datetime field (for Column Headings)
			(with optional year filter for "Quarter" and "Month")

Optional Excel-style Popup Filter

and relative filter for datetime fields

Relative Days	Relative Day Periods	Relative Weeks
Relative Months	Relative Years	Past/Future

Extended Filters with Validation and Default Value

Collapsible extended filter panel above the report. Display the extended filter as a text box, combobox, listbox, checkboxes or radio buttons with default value as the default filter of the report. If the field is a date field, you can use textbox with optional popup calendar, or you can choose to display the filter as a combobox of year/quarter/month/day.

Extended Filters also support relative filters for datetime fields like popup filters.

Optional Summary at Various Levels

• Grouping level summary
• Page Summary
• Grand Summary
  

Optional Advanced Security (User ID and User Level) (See Security Settings)

Optional HTML Settings with Preview (See HTML Settings)

Menu Editor

You can re-order the menu items, add your own menu items for external pages or custom URL and use submenus.

Note: The submenus will be generated by the graphical extension (previously graphical template) available for registered users only.

Create, Alter and Drop Views

Other Features

• Supports MySQL, PostgreSQL, Oracle (Linux/Windows), Microsoft Access and SQL Server (Windows only)
  
  
• Various PHP options. Locale, default date formats. mysqli, etc. (See PHP Settings)
  
  
• Saving and restoring project from Project File
  
  
• Synchronize project settings with changes in database
  
  
• Creates virtual directory in IIS automatically
  
  
• CSS stylesheet
  
  
• Export to HTML/Word/Excel/Email/PDF
  
  
• Email log to text file or database table with protection against email abuse
  
  
• User selectable page size
  
  
• Table-specific page options
  
  
• Dynamic table loading
  
  
• Auto-login
  
  
• Multi-Language project
  
  
• Multi-Language Property Editor
  
  
• BLOB field as image in report
  
  
• Vertical/Horizontal menu (graphical extension available for registered users only)
  
  
• Server events and client scripts
  
  
• Code repository
  
  
• MD5 and case-sensitive password
  
  
• Custom View with Built-in Visual Query Builder. Supports converting existing Custom View to database view.
  
  
• Customizable template

Note: PHP Report Maker is a reporting tool, all reports are read-only, data modification is not supported.