Solved

Report Total On Last Page  (Oracle Reports 6i)

Posted on 2002-06-05
2
1,910 Views
Last Modified: 2012-06-21
In a report where a page total is printed on all pages, i  want to print a report total in the on the last  place instead of page total on the "same place". how can i achieve this .
is that is possible to obtain  a cumilative page wise total on all pages
(ie  on second page pg total of the first page + pg total of the second page )
0
Comment
Question by:rajeshnalankal
[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
2 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 100 total points
ID: 7123808
Maybe this solution from Metalink will help you:

PROBLEM DESCRIPTION:
====================

How can you create a running total to appear at the bottom of each page on a multi-page report?

SOLUTION DESCRIPTION:
=====================

1.  Create a group level summary column "CS_1" in the data model.
     Source = < field >
     Reset at: Report
     Function = Sum

2.  Create a Report level summary column "CS_2", (outside the group).
     Source = < CS_1 > 
     Reset at: Page
     Function = Last

3.  Create a field in the Layout Editor between the repeating frame and
           the Master Group Frame.

     Source = < CS_2 >
     General Layout
     Print Condition = All
0
 

Author Comment

by:rajeshnalankal
ID: 7311800
hi

thanks
raj
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

695 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