Reporting FAQ

  • Documentation of ]po[ tables for reporting
  • Reporting via Crystal Reports
  • New report doesn't show in list of reports

 

Documentation of ]po[ tables for reporting

> Where do I find information on ]po[ tables for reporting?

 

Please see the ]po[ Data Model tutorial. This PPT will introduce you to the structure of the database.

Apart from that we recommend to install pgAdminIII (is already installed inside the ]po[ VMware installer). pgAdminIII allows you to browse the tables and their columns.

Finally: Please consider attending our yearly Developer Conference in September in Barcelona. The Data-Model and reporting are the main topics during the tutorial sessions.

Reporting via Crystal Reports

 > Is it possible to write reports outside of ]po[?

 

Yes, we have seen many customers creating reports in Crystal Reports or MS-Access. You can even store the reports in the filestorage package to somehow integrate these external reports.

The main downside of external reports is permissions and the necessity to install an ODBC-Driver at each user's computer. Integrated reports don't need the driver and allow you to set permissions using the normal "Menu" administration screen.

New report doesn't show in list of reports

> I have created a new report, but I don't see the
> tab in the "Reporting" section

 

This bug has been fixed in ]po[ V3.4.0.6. for manually created reports.

In earlier versions and after the installation of a new reporting package please go Admin -> Menus. Just loading this page will call a procedure to recalculate the report hierarchy (which is implemented using Menus).

  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

E-08907 Hospitalet de Llobregat (Barcelona)

 Tel Europe: +34 932 202 088
 Tel US: +1 415 429 5995
 Mail: info@project-open.com