?
Solved

hide header section oracle report

Posted on 2014-04-01
23
Medium Priority
?
843 Views
Last Modified: 2014-04-13
hi
how to remove the header section of oracle report
thanx
0
Comment
Question by:NiceMan331
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 12
  • 11
23 Comments
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39968822
do you mean an sql query, or a report generated by an oracle report..?

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
0
 

Author Comment

by:NiceMan331
ID: 39969963
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
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39970153
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;
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:NiceMan331
ID: 39975121
sorry for delay , but i lost the internet connection in my office
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
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39975738
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..
0
 

Author Comment

by:NiceMan331
ID: 39980090
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?
0
 

Author Comment

by:NiceMan331
ID: 39990983
wasim
sorry just i got internet connection
here is a snapshot of the report preview
where is the header frame ?
rep-1st.bmp
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39991013
ok.. show me the object navigator with all menus expanded/collapsed..!!
0
 

Author Comment

by:NiceMan331
ID: 39991033
0
 

Author Comment

by:NiceMan331
ID: 39991034
0
 

Author Comment

by:NiceMan331
ID: 39991036
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39991046
click on M_13 object in the body section,, you haven't collapsed it.. show me that also
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39991050
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..
0
 

Author Comment

by:NiceMan331
ID: 39991161
sorry , i attached different report which has no header page
here are the correct one
rep-5.JPG
rep-6.JPG
rep-7.JPG
0
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 1000 total points
ID: 39991189
ok.. do a right click on M_13 and click on plsql editor

and see if you get this type of code somewhere


function M_13FormatTrigger return boolean is
begin
 
  return (TRUE);
end;

check the same for R_2 also, one among these objects constitutes to your header
0
 

Author Comment

by:NiceMan331
ID: 39991233
when i changed the code of M_13 , the first page still displayed , but the detials of the report disappeared
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39991256
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..!!
0
 

Author Comment

by:NiceMan331
ID: 39991261
i changed only m_13
function M_13FormatTrigger return boolean is
begin
  
  return (false);
end;

Open in new window


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;

Open in new window

0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39991379
could you show me the report output before and after the change..!!!

the code looks fine. it should return FALSE
0
 

Author Comment

by:NiceMan331
ID: 39991428
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
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39991458
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..
0
 

Author Comment

by:NiceMan331
ID: 39992268
Ok , but regarding R13 , it is body section and not header section , should adjust it ?
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39992277
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...!!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question