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

Posted on 2001-07-12
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 ?
Question by:yallamati
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

Expert Comment

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,

Usama Munir

Expert Comment

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).

Accepted Solution

UsamaMunir earned 50 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.
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.


Expert Comment

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.



** 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.
LVL 49

Expert Comment

ID: 7053142
Recommended disposition:

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

DanRollins -- EE database cleanup volunteer

Expert Comment

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

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

739 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