| Problem in display summary column in reports [message #127934] |
Thu, 14 July 2005 04:01  |
awasthi_jaideep
Messages: 3
Registered: June 2005
Location: delhi
|
Junior Member |
|
|
hi all,
i facing a problem in report 6i.
In my report total no of record 1004 and i want to show 9 record in a one page,its ok but the problem arises when i want to show the total of a column at the fourth page(or after 9*4=36 record).
For this i take a summary column and set the property reset at page level.This give only page wise total but i want to show total not pagewise but after four page.
i use everything like formula column,report trigger,format trigger,report property like max horizontal body page,max vertical body page,section property like Horizontal Panels per Page,Vertical Panels per Page.
what i can do i could not understand.
plz help me.
i wait ur response.
jaideep
|
|
|
|
| Re: Problem in display summary column in reports [message #128712 is a reply to message #127934] |
Wed, 20 July 2005 04:43  |
dmalleswararao
Messages: 4
Registered: July 2005
|
Junior Member |
|
|
hi jaideep
After creating summary column,
1. change the property RESET AT->PAGE,
2. Create a format trigger like this to print the total of a column in forth page only
function M_G_SNO_FTRFormatTrigger return boolean is
page_no number;
begin
srw.get_page_num(page_no);
if page_no = 4 then
return (TRUE);
else
return (FALSE);
END IF;
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
