Working with Reportman

Previous Next

Different tables in TurboCASH5 must be used for a report. The most commonly used tables and its relationships will be outline in this document.

Value have been added to the connections, interaction, relationship to force and interact responses with the datasets and database connections as a plugin / extensions from TurboCASH5 to Reportman.  The Zeos Database Objects connection will basically always render a message (i.e. “Test connection passed” ). This is the leader Opensource database driver technology for Delphi/Kylix/Builder.

Should you fail with this successful connection, it may imply that one of the following may need attention:

Installation of TurboCASH5 (Did not install the Firebird database engine), only installed the Single user Embedded version).

May have more than one Alias in the reportman (*.rep) files – lets call it badly designed reports or document layout files.

Corrupted data in the database, etc.

The data in the database, for example; date format, currency, time, etc., is system locale (Regional and Language) specific.

If TurboCASH5 have been installed on a Windows machine, the Language and Regional settings may be changed if you click on the Set Windows Date/Format/Style button located in Setup → Company info (Options).  In Windows operating you may change this in the Control Panel (Regional and Language settings).  This will for example display the correct date format as per your countries' regional settings on all reports output and screens in TurboCASH5.

To develop or edit reports in TurboCASH5, you need to use the built in Reportman in TurboCASH5. Some extra functions have been added to Reportman in TurboCASH. Some of these extra functions are;  'GETTEXTLANG' ,  'RETURNSQL' , 'NUMBERTOWORDS' , 'GETPRICE', etc.  Another important feature is Data access configuration.

All reports in TurboCASH5 are fully translatable via the 'GETTEXTLANG' function.  Basically all document layout files and reports designed in Reportman can be displayed in any of the languages by changing the Language in the Start → Switch language option.

Language files may be edited in Setup → Tools → Customise language. These are stored in the .../Bin/Languages folder.

All objects are added to a selected page structure. In the example of the TestInvoice.rep. On the Page header we have a number of expressions (from the COMPANYINFO and the DOCUMENTHEAD datasets), an image (company logo) (from the COMPANYINFO dataset) and some labels (static text), e.g. Telephone, Fax and E-mail Address.

If you click on a selected object on the list, the object will be displayed on the grid. You may then easily edit move resize or set the properties for the object.

Should you receive an error printing and previewing the report, note the name and  number of the object (expression, etc.).

Created with the Personal Edition of HelpNDoc: Free Web Help generator