Report Builder - Get Data from Available Pipeline: Difference between revisions
From eStream Software
(→Steps) |
(→Steps) |
||
Line 11: | Line 11: | ||
<syntaxhighlight lang="delphi"> | <syntaxhighlight lang="delphi"> | ||
SQL_6 := 'SELECT DocKey, Tax, TaxRate, Sum(LocalAmount) LocalAmount, Sum( | SQL_6 := 'SELECT DocKey, Tax, TaxRate, Sum(LocalAmount) LocalAmount, Sum(LocalTaxAmt) localTaxAmt, '+ | ||
' | 'Description FROM Document_Detail ' + | ||
'Where Tax <> ''''' + | 'Where Tax <> ''''' + | ||
'GROUP BY Dockey, Tax, TaxRate'; | 'GROUP BY Dockey, Tax, TaxRate'; |
Revision as of 05:59, 3 February 2016
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
Last Script Update : 03 Feb 2016
SQL_6 := 'SELECT DocKey, Tax, TaxRate, Sum(LocalAmount) LocalAmount, Sum(LocalTaxAmt) localTaxAmt, '+
'Description FROM Document_Detail ' +
'Where Tax <> ''''' +
'GROUP BY Dockey, Tax, TaxRate';
- More Coming soon...
See also
- Report Designer
- Others Customisation