(Created page with "==Introduction== * Coming soon... ==See also== * Report Designer * Others Customisation") |
|||
Line 1: | Line 1: | ||
==Introduction== | ==Introduction== | ||
* | Sometime in the report you might wanted some extra information or further analysis from the report itself but you not able to select in the report design. So you had to self query to get the extra information or further analysis. | ||
==Steps== | |||
Below is Example doing following actions | |||
* Get data information (Tax, Tax rate, LocalAmount, LocalTaxAmt) | |||
* Group the data by Tax code | |||
[[File:FR-GetAvailDB-01.jpg|center]] | |||
:01. Click '''Code''' tab & scroll down look for '''procedure SetUp''' | |||
:02. Copy below script & paste between the '''begin''' & '''end;''' in '''procedure SetUp''' | |||
<syntaxhighlight lang="delphi"> | |||
SQL := 'SELECT Dockey, Tax, TaxRate, Sum(CAST(LocalTaxAmt AS REAL)) LocalTaxAmt, ' + | |||
'Sum(CAST(LocalAmount AS REAL)) LocalAmount '+ | |||
'FROM Document_Detail ' + | |||
'WHERE Tax <> '''' ' + | |||
'GROUP BY Dockey, Tax, TaxRate'; | |||
AddDataSet('GSTAmt', ['Tax', 'TaxRate', 'LocalTaxAmt', 'LocalAmount']) // Create New Pipeline | |||
.GetLocalData(SQL) // Execute the Query | |||
.SetDisplayFormat(['LocalTaxAmt', 'LocalAmount'],<Option."AccountingValueDisplayFormat">) // Set Display Format | |||
.LinkTo('Main', 'Dockey', 'Dockey'); // Link the New Pipeline (eg here is to link with Main Pipeline) | |||
</syntaxhighlight> | |||
==See also== | ==See also== | ||
* [[Report Designer]] | * [[Report Designer]] | ||
* Others [[Customisation]] | * Others [[Customisation]] |
Revision as of 02:53, 18 November 2015
Introduction
Sometime in the report you might wanted some extra information or further analysis from the report itself but you not able to select in the report design. So you had to self query to get the extra information or further analysis.
Steps
Below is Example doing following actions
- Get data information (Tax, Tax rate, LocalAmount, LocalTaxAmt)
- Group the data by Tax code
- 01. Click Code tab & scroll down look for procedure SetUp
- 02. Copy below script & paste between the begin & end; in procedure SetUp
SQL := 'SELECT Dockey, Tax, TaxRate, Sum(CAST(LocalTaxAmt AS REAL)) LocalTaxAmt, ' +
'Sum(CAST(LocalAmount AS REAL)) LocalAmount '+
'FROM Document_Detail ' +
'WHERE Tax <> '''' ' +
'GROUP BY Dockey, Tax, TaxRate';
AddDataSet('GSTAmt', ['Tax', 'TaxRate', 'LocalTaxAmt', 'LocalAmount']) // Create New Pipeline
.GetLocalData(SQL) // Execute the Query
.SetDisplayFormat(['LocalTaxAmt', 'LocalAmount'],<Option."AccountingValueDisplayFormat">) // Set Display Format
.LinkTo('Main', 'Dockey', 'Dockey'); // Link the New Pipeline (eg here is to link with Main Pipeline)
See also
- Report Designer
- Others Customisation