Report Builder - Get Data from Available Pipeline

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;

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...

Introduction

Steps

See also