NiceMan331
asked on
hide header section oracle report
hi
how to remove the header section of oracle report
thanx
how to remove the header section of oracle report
thanx
ASKER
It is oracle report as clear in my question , and not an SQL query , But plz explain more about how to adjust the layout model in expand explanation please
Ok.. here you go..
Am giving you the steps of oracle reports 6i..
check out the attached document for the screenshots..
here is the summary of the steps
Considering a simple emp table report
1. Open the report in preview mode
2.click on the header and select the header frame only
3.do a right click and open up the property pallette of header section
4. Click on Format Trigger option in Advanced Layout Section
and change the boolean variable value to FALSE
Mine had code like this..
function M_G_EMPNO_HDRFormatTrigger return boolean is
begin
return (TRUE);-- Change the TRUE to FALSE
end;
Am giving you the steps of oracle reports 6i..
check out the attached document for the screenshots..
here is the summary of the steps
Considering a simple emp table report
1. Open the report in preview mode
2.click on the header and select the header frame only
3.do a right click and open up the property pallette of header section
4. Click on Format Trigger option in Advanced Layout Section
and change the boolean variable value to FALSE
Mine had code like this..
function M_G_EMPNO_HDRFormatTrigger
begin
return (TRUE);-- Change the TRUE to FALSE
end;
ASKER
sorry for delay , but i lost the internet connection in my office
anyhow , i tried , but
when i open property pallete , blank page opened , nothing else
anyhow , i tried , but
3.do a right click and open up the property pallette of header section
when i open property pallete , blank page opened , nothing else
2.click on the header and select the header frame only
have you followed steps in correct manner..
Else give the screenshot of your object navigator with collapsed menus..
have you followed steps in correct manner..
Else give the screenshot of your object navigator with collapsed menus..
ASKER
sorry waseem
i still have no internet in the office
i'm typing now from my home
i will try to have a flash memory to copy screenshot as per your request
you need layout model also , or just object navigator?
i still have no internet in the office
i'm typing now from my home
i will try to have a flash memory to copy screenshot as per your request
you need layout model also , or just object navigator?
ASKER
wasim
sorry just i got internet connection
here is a snapshot of the report preview
where is the header frame ?
rep-1st.bmp
sorry just i got internet connection
here is a snapshot of the report preview
where is the header frame ?
rep-1st.bmp
ok.. show me the object navigator with all menus expanded/collapsed..!!
ASKER
ASKER
ASKER
click on M_13 object in the body section,, you haven't collapsed it.. show me that also
also besides the object M_13.. as per your layout.. i can't see any header.. which one do you want to remove in actual?
if you can some me some live preview with garbage/junk data it would be easy to understand..
if you can some me some live preview with garbage/junk data it would be easy to understand..
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
when i changed the code of M_13 , the first page still displayed , but the detials of the report disappeared
what did you change...!!, did you found this only in M_13 or is it present in R_2 also,.
I mentioned one of them could do the work.. which one am also not sure.. post the code present there..!!
I mentioned one of them could do the work.. which one am also not sure.. post the code present there..!!
ASKER
i changed only m_13
and here is the code of r_2 ( i didn't touch it )
function M_13FormatTrigger return boolean is
begin
return (false);
end;
and here is the code of r_2 ( i didn't touch it )
function R_2FormatTrigger return boolean is
begin
if nvl(:prn_flg,0) = 0 then
return (TRUE);
elsif nvl(:prn_flg,0) = 1 then
if nvl(:op_deb,0) = 0 and nvl(:op_cr,0) = 0 and nvl(:tr_deb,0) = 0 and nvl(:tr_cr,0) = 0 then
return(false);
else
return(true);
end if;
end if;
return (TRUE);
end;
could you show me the report output before and after the change..!!!
the code looks fine. it should return FALSE
the code looks fine. it should return FALSE
ASKER
actually , i did one thing
i delete all items in the first page
then it ok now
it hide the first page , and directly show the second page
i delete all items in the first page
then it ok now
it hide the first page , and directly show the second page
ok.. you got what you want??
.. but thats the thing you have to do.. just have to edit the trigger,. so that the boolean value returns false.. in your header section..
in case your header has more than one entity, you have to do this to every entity..
if you still face any issues, pls post the screenshot for a better clarity..
.. but thats the thing you have to do.. just have to edit the trigger,. so that the boolean value returns false.. in your header section..
in case your header has more than one entity, you have to do this to every entity..
if you still face any issues, pls post the screenshot for a better clarity..
ASKER
Ok , but regarding R13 , it is body section and not header section , should adjust it ?
yeah.. its fine.. i think you have designed the header in the body form in layout editor.. thats why i had asked you for a sample..!!
if you get it then its fine...!!
if you get it then its fine...!!
if that is an sql, you can do it by using
set heading off;
incase of oracle reports, you have to edit the Layout Model