[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

How to get present line count (like &physical page) in oracle reports

Posted on 2001-07-12
6
Medium Priority
?
904 Views
Last Modified: 2012-05-04
while generating a report in oracle how to get present line count? We are getting present page no from variable "&physical_page". similarly, Is there any provision to get the line number during page formatting. Is there any system variable pertaining to line number in any one of the oracle packages.
For example: page size is 66x80
page brake occurs after line number 66, how ?
0
Comment
Question by:yallamati
[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
6 Comments
 
LVL 3

Expert Comment

by:UsamaMunir
ID: 6276531
if u are using Oracle Reports , Do this

1) write your Query like this

select 1 SNO, [column1, column2, column3,.........]
<rest of query>

2) Create a Summry Column in the Data Model of the reports in the in the same group as the rest of the columns. The source of that summary column (CS_1) should be SNO (first column of the above query)

4) Now in the layout model create a text feild in the same repeating group as the columns of above query and set the source of this text feild to be the Summry column (CS_1)

5) Every line now will be numbered 1,2,3,4 etc.

I hope it solves Your Problem,

Regards
Usama Munir
0
 
LVL 3

Expert Comment

by:UsamaMunir
ID: 6276568
And for Ur question about page break if u want to page break after specific amount of rows do this

To add a page break:

1     In the Live Previewer view, click any field that is part of the frame at which you want to insert a page break.  

2     Click  (Select Parent Frame) in the toolbar.

3     Choose ToolsProperty Palette.  


n     before or after the selected frame:  under the General Layout node, set the Page Break Before or Page Break After property to Yes.

4     To set a page break after a certain number of rows of output on each page:  under the Repeating Frame node, set the Maximum Records per Page property to the number of rows you want to display on each page.

5     To display icons that identify where page breaks are set, choose ViewPage Breaks in the Layout Model view:  (icons display as  for page break before and  for page break after).
0
 
LVL 3

Accepted Solution

by:
UsamaMunir earned 200 total points
ID: 6276579
Sorr i forgot to add in my first comment, the summary column that u create , it's summary function should be SUM and source should be SNO.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 6

Expert Comment

by:Mindphaser
ID: 7038114
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7053142
Recommended disposition:

    Accept UsamaMunir's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7054102
Thanks, Dan.
I finalized this today and will monitor it in the event an adjustment is needed.
Moondancer - EE Moderator
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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…

656 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