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


Chapter 3 Tools : $RPTOVERLAP

$RPTOVERLAP
Designates the report tables or report fields that are not to be printed on the overlapping page of a merged report. (C)
Invocation
CALL $RPTOVERLAP(report, reporttable, reportfield, blankoverlap)
 
The name of the report to be printed. Its syntax is C (fixed-length character string) with length 16.
The name of the report table to which the attribute defined in the blankoverlap argument applies. Its syntax is C with length 16.
The name of the report field on a title row to which the attribute defined in the blankoverlap argument applies. Its syntax is C with length 16.
This argument is used to override a blankoverlap attribute defined in a report table definition. It is also used to override a previous call to $RPTOVERLAP within the existing transaction. Valid values are:
Usage Notes
If a report table is specified, and not a report field, the blankoverlap argument applies to the title rows of the entire report table.
Example
The following example rule merges two reports, defines $RPTPARMS to provide an overlapping page, and deletes the report fields $RPTDATE and $PAGE from the resulting overlapping page:

 
RPTOVERLAP_1;
_
_ ------------------------------------------------------------------------
_ ------------------------------------------------------------+-----------
_ FORALL EMPLOYEE_USER('USR40'): | 1
_ SAL_SUM2_RT.* = EMPLOYEE_USER.*; |
_ INSERT SAL_SUM2_RT('SALARY_SUM2'); |
_ CALL COMMIT_TEST; |
_ END; |
_ FORALL EMPLOY_DEPT_USER(10, 'USR40'): | 2
_ DEPTNO_SALARY_RT.* = EMPLOY_DEPT_USER.*; |
_ INSERT DEPTNO_SALARY_RT('DEPTNO_SALARY'); |
_ CALL COMMIT_TEST; |
_ END; |
_ CALL $RPTOVERLAP('DEPT_SALARY','DEPT_SALARY_RT', | 3
_ '$RPTDATE', 'Y'); |
_ CALL $RPTOVERLAP('DEPT_SALARY','DEPT_SALARY_RT', | 4
_ '$PAGE', 'Y'); |
_ CALL $RPTPRINT('SALARY_SUM2', 'SCR'); | 5
_ CALL $RPTPARMS('DEPT_SALARY', '', '', 'N', ''); | 6
_ CALL $RPTPRINT('DEPT_SALARY','SCR'); | 7
_ ---------------------------------------------------------------------
_ ON ERROR :
CALL ENDMSG(GET_ERRMSG(RETURN_MESSAGE));

 
Resulting Output
Pressing PF2 after executing this rule displays the following screen:

 
Employee/Salary Report by Department 1
As of MAY 24/00
Department # Department Name Total Salary
50 EDUCATION 1385.00
70 PUBLICATIONS 1370.00
MANAGER:JOHN DUBINSKY
DEPTNAME:EDUCATION
NAME SALARY
------------------ ----------------
STEVENSON 700.00
DHILLON 685.00
DEPTNAME:PUBLICATIONS
CROFTON 675.00
POIRIER 695.00
GRAND TOTAL 2765.00
Personnel Department
Internal Confidential

 

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