Enterprise Edition of PHPRunner includes the online report/chart builder that allows you to view, create, edit and delete reports and charts in the web browser.

To enable the online report/chart builder, check off the Web Reports check box on the Miscellaneous page and build the project. Then launch online report/chart builder by running webreport.php in the browser (e.g. http://www.yourwebsite.com/project1/webreport.php). Online report/chart builder uses PHPRunner project security model. So if you use a login page, you need to logon to your application first.

Working with online report/chart builder

Start page presents you with the list of charts and reports. If your project uses permissions, charts and reports are divided into shared and private ones.

You can view, edit or delete charts and reports if the permissions allow you to do so. Also you can create new chart or new report.

While viewing a report or chart you can narrow the finding using Advanced search. While viewing a report you can also print the current page or the whole report, open a report as Microsoft Word or Microsoft Excel document.

Example of Web report:

On the Admin page you can select tables to be available for creating web reports and charts.

The Admin page is available only to the web reports and charts administrator that can be assigned on the Security -> Permissions page.

A user with admin permissions can create/edit/delete custom SQL queries using the Custom SQL button. The custom SQL queries later may be used by other users as a datasource for reports and charts. For more information, see Custom SQL.