Report Builder - Get Data from Available Pipeline: Difference between revisions
From eStream Software
(→Steps) |
(→Steps) |
||
Line 8: | Line 8: | ||
Last Script Update : 03 Feb 2016 | Last Script Update : 03 Feb 2016 | ||
[[File:RB-GetAvailDB-01.jpg|800 px|center]] | |||
:01. Click on '''Calc''' Tab | |||
:02. Right click here & Select '''Module''' | |||
:03. Select Declarations | |||
:04. Select Variables | |||
:05. Add new/to existing as below variable | |||
<syntaxhighlight lang="delphi"> | |||
var | |||
SQL_6: String; | |||
</syntaxhighlight> | |||
<syntaxhighlight lang="delphi"> | <syntaxhighlight lang="delphi"> |
Revision as of 06:33, 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
- 01. Click on Calc Tab
- 02. Right click here & Select Module
- 03. Select Declarations
- 04. Select Variables
- 05. Add new/to existing as below variable
var
SQL_6: String;
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