Write your own Reports in TurboCASH 5
Download this 67 Page Manual TurboCASHReportman.pdf
TurboCASH uses the powerful Reportman Report writer. This is a guide that assume no prior knowlege and shows you how to write you own reports. A small knowlege of SQL and Firebird is required for really powerful reports.
One of the apps is to format your own invoices and documents
Table of Contents
CREATE A NEW REPORT .................................................................................................3
Create a new empty report..........................................................................................3
Empty report.............................................................................................................3
New report ...............................................................................................................4
Add COMPANYDATA dataset to the New report...............................................................5
Add COMPANYDATA data to the New report...............................................................7
Add COMPANYDATA data labels to a New report.........................................................8
Add COMPANYDATA Static labels to a New report....................................................8
Add text labels.......................................................................................................8
Format text...........................................................................................................9
Insert a Simple drawing Horizontal line.....................................................................9
Add COMPANYDATA data Dynamic labels (Translations) to a New report..................10
REPORT DETAIL............................................................................................................10
Add a New dataset....................................................................................................10
Preview the data tables (Dataset)...............................................................................11
Link the SubReport-0(No Dataset) to the Main Dataset (i.e. DEBTORLIST).......................12
Add data to the Detail section of the report .................................................................12
Preview the report....................................................................................................13
Set the sequence (order) of the data in the report........................................................13
Add headings to the Data on the Details section of the report .......................................14
PAGE HEADERS............................................................................................................16
Add (insert) Page header ..........................................................................................17
Move Page header....................................................................................................17
Add Detail to Page header.........................................................................................18
Page header - Print company details only on the first page............................................21
PAGE FOOTERS ...........................................................................................................22
Add data to Page footers...........................................................................................22
Page footer settings..................................................................................................23
Setting for Page footer..........................................................................................23
Two pass report setting ........................................................................................23
TRANSLATIONS OF LABELS VIA THE LANGUAGE FILES......................................................24
Expressions for translation of text and labels................................................................24
Find labels in the language file ..................................................................................24
Add translation expressions to the report.....................................................................25
FINALISE THE REPORT..................................................................................................27
Save and rename the report......................................................................................27
Rename the report....................................................................................................27
Rename in Report man screen................................................................................27
Rename in File explorer ........................................................................................27
Add the report to the menus......................................................................................28
Printing your report from the User reports menu..........................................................28
PARAMETERS ..............................................................................................................30
Add the sequence (sort parameter).............................................................................30
Add the Sequence (Order) Parameter to the report...................................................33
Add SEQ and SEQTX String parameters...................................................................33
Add SEQTX2 String Substitute parameter................................................................35
Add @ORDER Sequence parameter to the Dataset Sql...............................................36
Test the Sequence parameter on the report ............................................................37
Add the Sequence parameter to the report printout .................................................37
Parameter files.....................................................................................................39
Test / Print the new report with the sequence parameter...........................................40
Lookup Parameters - FROM ACCOUNT … TO ACCOUNT .................................................41
Add lookup to the Parameters selection screen.........................................................41
Move resize parameters ....................................................................................41
Add the Lookup parameters ..............................................................................42
Add lookup (From account and To account) parameters to report ...........................47
Add From Account (SACCOUNTCODE) String parameter........................................47
Add From Account (SACCOUNTCODETX) String Substitute parameter......................48
Add To Account (SACCOUNTCODETO) String parameter.........................................49
Add To Account (SACCOUNTCODETOTX) String Substitute parameter......................50
Add From account and To account Lookup parameters Sql to the Dataset................51
Test / Print the new report with the From account and To account parameter...........52
Add From account … To Account parameters to the printout ......................................53
Test / Print the new report with the Lookup parameters.............................................55
EXPRESSIONS - ADVANCED...........................................................................................56
Account type ...........................................................................................................56
New line / Line break in Expressions...........................................................................58
CREATE A NEW REPORT FROM AN EXISTING REPORT .......................................................61
Create a copy of an existing report ............................................................................61
Edit the report .........................................................................................................61
Edit the parameters .................................................................................................63
Edit the Sequence parameter ....................................................................................63
Edit the From account ... To account parameters.........................................................64
BUILD USER REPORTS MENU STRUCTURE.......................................................................67
