Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix B Merging Reports : Merging Reports

Merging Reports
Reporting Tools
You can merge reports to make them appear as one report. To merge a report you use the $RPTPARMS tool. To make selected visual changes to the merged reports you can also use the $RPTOVERLAP tool, in addition to $RPTPARMS. Changes that you make using $RPTOVERLAP override changes that are made using the Report Definer. For more information about these tools refer to TIBCO Object Service Broker Shareable Tools.
EMP_EXPENSE_MRG Rule
The EMP_EXPENSE_MRG rule merges the reports EMP_EXPENSE and DEPT_EXPENSE_SUM. No changes are made to the length or width of the second report, DEPT_EXPENSE_SUM, a new page is ejected between the two reports, and the page numbers run consecutively throughout the report.

 
EMP_EXPENSE_MRG;
_
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ FORALL $EMPLOYEE_EXPENS : | 1
_ MONTHLY_EXPENSE.MONTH_NUMBER = $DATE_PIC('MM', |
_ $EMPLOYEE_EXPENS.MONTH); |
_ FORALL EMPLOYEE_EXPENSE($EMPLOYEE_EXPENS.MONTH) : |
_ MONTHLY_EXPENSE.* = EMPLOYEE_EXPENSE.*; |
_ INSERT MONTHLY_EXPENSE('EMP_EXPENSE'); |
_ DEPT_EXPENSE_SUM.* = EMPLOYEE_EXPENSE.*; |
_ INSERT DEPT_EXPENSE_SUM('DEPT_EXPENSE_SUM'); |
_ END; |
_ END; |
_ CALL $SETRPTMEDIUM('EMP_EXPENSE', 'VISUAL', 'SCR'); | 2
_ PRINT EMP_EXPENSE; | 3
_ CALL $RPTPARMS('DEPT_EXPENSE_SUM', '', '', 'Y', ''); | 4
_ CALL $SETRPTMEDIUM('DEPT_EXPENSE_SUM', 'VISUAL', 'SCR'); | 5
_ PRINT DEPT_EXPENSE_SUM; | 6
_ ---------------------------------------------------------------------------

 
See Also
TIBCO Object Service Broker Programming in Rules for more information about editing rules.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved