Caché Report Designer

Click here for a Flash demo of the ReportDesigner in action !

There are several tools available to create all sorts of reports in Caché , but there is only one report tool which is designed especially for Caché, using the most powerfull techniques available. ReportDesigner is not using ODBC like its competitors, but uses the Caché Object model to give you the easiest and most performant way to create and run reports.

ReportDesigner is build around Caché, which gives it unique capabilities not found in other commercial report generators :

• Use the query wizard to generate queries, or create queries yourself by using SQL. The query wizard is a true wizard, using information from the Caché database that can not be used by other ODBC tools (like automatically linking tables together).
• Use ready-made Object Queries created in the Caché Classes to eliminate the need to know a query language like SQL.
• Caché applications not having their data (globals) mapped into classes/tables can also use special object classes that call custom routines to retreive data
• Use class methods to retrieve data from any field in the report
• Store report definitions inside Caché, eliminating the need to install report definitions on client pc's or shared networks.
• Use a language dictionary stord in Caché to help you translate reports automatically
• Use multiple levels of detail, each detail can use it's own query. Each detail group has header and footer sections.
• Included reports for each namespace : Defined Classes, Defined Reports

The ReportDesigner consists of two major parts :

• Design and test your report definitions in the user-friendly designer tool.
• Run existing reports by using an executable that can be easily called from Caché (CSP, weblink, or any routine) or any windows development tool, output can go to a printer or a PDF document. We also provide a component for Delphi users.

The report consist of several sections called 'bands' : each detail level consists of 3 bands (Header, Detail and Footer) and can have its own query (lookup) in the database.

Data can be retrieved via SQL (thru a SQL wizard), Object queries or m/mumps/cos-routines.

A field can be a calculated field, by directly calling any Caché classmethod :

The SQL-script is automatically generated when you select/deselect fields in the form.

The Report designer can be used as a stand-alone product, and you can print/preview reports directly from a Delphi application by using the CacheObjectReport component.

You can also print the report from Caché to a printer or to a PDF document :in this way you can use use the Reports from within a web application like weblink or CSP, and produce PDF documents in the browser.

Click here to see a sample PDF from a report called Classes that is shipped with the ReportDesigner.

The report Classes will print class documentation for any selected class(es), in this case, we have selected the package 'Cinema' of the Samples Namespace :