| restricting records per page in matrix report at runtime [message #88920] |
Sat, 14 June 2003 06:21 |
subhasish
Messages: 33
Registered: May 2000
|
Member |
|
|
/*****************************************
REPORT TYPE = MATRIX
MATRIX ROW FIELD = EMP
MATRIX COL FIELD = DEPT
MATRIX CELL VALUE= SALARY
WHAT I NEED IN MATRIX REPORT ?
1.PER PAGE n RECORDS ( n WILL PASS FROM PARAMETER )
2.PAGE WISE TOTAL SALARY AT BOTTOM OF EACH PAGE
3.CURRENT PAGE TOTAL WILL DISPLAY AT THE TOP OF THE NEXT PAGE AS CARRY FORWARD
*****************************************/
create table test_matrix(dept varchar2(10), emp varchar2(10),salary number(6));
declare
CNT NUMBER(6) := 0;
begin
for i in 1..50 loop
CNT := CNT + 1;
insert into test_matrix(dept,emp,salary)
values('D1','E'||CNT,CNT*100);
insert into test_matrix(dept,emp,salary)
values('D2','E'||CNT*2,CNT*200);
insert into test_matrix(dept,emp,salary)
values('D3','E'||CNT*3,CNT*300);
insert into test_matrix(dept,emp,salary)
values('D4','E'||CNT*4,CNT*400);
insert into test_matrix(dept,emp,salary)
values('D5','E'||CNT*5,CNT*500);
end loop;
end;
/
COMMIT;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
