Report Builder - Get Data from Available Pipeline

From eStream Software
Revision as of 06:39, 3 February 2016 by Twfaung (talk | contribs) (→‎Steps)

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

RB-GetAvailDB-01.jpg
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;
RB-GetAvailDB-02.jpg
06. Select Events
07. Select OnCreate
08. Copy below script & paste to here
  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