Try OpenEdge Now
skip to main content
Business Process Portal Manager's Guide
Creating and executing reports in Business Process Portal : Understanding reports : Report types

Report types

You can manage and review Business Process Server applications using four types of reports listed below:
*Query (Application) reports — Enables you to manage and monitor a single application. You can define reports that perform filtering on various task attributes for a single application.
*Multiapplication reports — Enables you to manage and monitor multiple applications at the same time. You can create a report that lists all application instances for a particular user independent of the application. Also, you can define reports that perform filtering on various task attributes.
*External reports — Reports generated using external report servers. You can send parameters and values to report servers which generate reports accessible through the Management module of the Business Process Portal.
The following table describes the types of external reports:
Table 13. External report types
Report type
Reports generated using Crystal Reports tool.
Reports generated using Active Server Pages (ASP) in HTML format.
Reports generated using BPM SQL. This capability is integrated with Business Process Server, enabling you to place SQL statements in a file (you must use the *.bizsql extension for the database) for execution by the Management module. Typically, this file is stored in the <WebAppDir>\BizManage\reports folder under the path that your application server is using. The <WebAppDir> path is the value of the oebps.webappdir parameter from the OEBPS_HOME\conf\oebps.conf file. For example, for JBoss application server, the path is
*For Windows: OEBPS_HOME\jboss\webapps\deploy\sbm.war\BizManage\reports
*For UNIX: OEBPS_HOME\jboss\webapps\deploy\sbm.war\BizManage\reports
Once executed, Business Process Server formats the results and presents the output using standard HTML. Users can view only those BPM SQL reports for which they have been given permissions. These permissions are controlled using the Permission Create page in the Administration module. For more information on BPM SQL security, see the Business Process Portal Administrator’s Guide.
*Infopad reports — Enables you to provide a detailed analysis of an infopad associated with one or more applications.
Business Process Server offers a highly visual set of charts for infopad reports, which can help you monitor Business Process Server applications at a higher level. You can select from one of the following analysis formats:
*Table & Graph
*Excel Spreadsheet
For more information about infopads, see Progress OpenEdge Business Process Server: BPM Events User's Guide.