Report Builder - Get Data from Available Pipeline: Difference between revisions
From eStream Software
(→Steps) |
(→Steps) |
||
Line 44: | Line 44: | ||
[[File:RB-GetAvailDB-04.jpg|800 px|center]] | [[File:RB-GetAvailDB-04.jpg|800 px|center]] | ||
:15. Click Subreport icon | :15. Click Subreport icon | ||
:16. Click the place you wanted to print | :16. Click the place you wanted to show/print | ||
[[File:RB-GetAvailDB-05.jpg|center]] | [[File:RB-GetAvailDB-05.jpg|center]] | ||
:17. Right click the Sub report | :17. Right click the Sub report | ||
Line 57: | Line 57: | ||
::* Header - UnSelect | ::* Header - UnSelect | ||
::* Footer - UnSelect | ::* Footer - UnSelect | ||
[[File:RB-GetAvailDB-07.jpg|800 px|center]] | |||
:23. Click DBText Icon | |||
:24. Click the place you wanted to show/print | |||
:25. Select '''LocalAmount''' field | |||
:26. Repeat Step 23 to 25 for '''LocalTaxAmt''' field | |||
* More Coming soon... | * More Coming soon... | ||
Revision as of 10:03, 4 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;
- 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';
- 09. Select Event Handlers
- 10. Select procedure ReportBeforePrint
- 11. Copy below script & paste to here
LocalSQL_SELECT(plSQL_6, SQL_6, 'Dockey;Tax');
SetDataPipelineFieldLink(Main, plSQL_6, 'DocKey', 'DocKey');
- 12. Click File | Save As... to save the file (eg 0Sales Cash Sales 3 (GST 1))
- 13. Click File | Exit to exit the report design
- 14. Click Design again in the report designer for the file just save on Steps 12 (eg 0Sales Cash Sales 3 (GST 1))
- 15. Click Subreport icon
- 16. Click the place you wanted to show/print
- 17. Right click the Sub report
- 18. Untick the ParentWitdh & manual adjust the sub report width to the width you wanted
- 19. Select the Pipeline just create (eg plSQL_6)
- 20. Scroll till end
- 21. Click SubReport2:plSQL_6 tab
- 22. Click Report & set the following setting
- Tittle - Select
- Summary - Select
- Header - UnSelect
- Footer - UnSelect
- 23. Click DBText Icon
- 24. Click the place you wanted to show/print
- 25. Select LocalAmount field
- 26. Repeat Step 23 to 25 for LocalTaxAmt field
- More Coming soon...
See also
- Report Designer
- Others Customisation