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

  SQL_6 := 'SELECT DocKey,  Tax, TaxRate, Sum(LocalAmount) LocalAmount, Sum(Qty) Qty, Sum(LocalTaxAmt) localTaxAmt, Description '+ 
		   'FROM Document_Detail ' +
		   'Where Tax <> ''''' +
		   'GROUP BY Dockey, Tax, TaxRate';

• More Coming soon...

See also

• Report Designer
• Others Customisation