Working with Reportman
The Report designer allows you to create / edit or add reports and document layout files for Invoices, Credit notes, Quotes, Delivery notes, Purchase, Supplier returns and Orders.
Different tables in TurboCASH4 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 TurboCASH4 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 TurboCASH4 (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 TurboCASH4 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 the the Setup → System parameters → Company info (Options) menu. 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 TurboCASH4.
To develop or edit reports in TurboCASH4, you need to use the built in Reportman in TurboCASH4. Some extra functions have been added to Reportman in TurboCASH4. Some of these extra functions are; 'GETTEXTLANG' , 'RETURNSQL' , 'NUMBERTOWORDS' , 'GETPRICE', etc. Another important feature is Data access configuration.
All reports in TurboCASH4 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 File → Switch language option.
Language files may be edited in the Tools → Customise language menu. 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.).