What is summary column in Oracle Reports ?

Answer Posted / sheetal mittal

By summary column you can take sum,Average,minimum,maximum,
std Deviation,Variance and count of any of the field.It can
be reset at report or Page or Group level.

If you want to take sum page wise you cna set the property
of Reset At as Page.Similarly for others.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if u want to delete all these detail block etc what will happen in form

1760


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1492


i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2726


how report can be generated if we have the database designed in oracle 10g?

1688


how do u place it in required folder

1709


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1924


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

913


How to create Drill down report?

1911


what are the new features introduced in oracle form services in 11g release 2?

817


Name the different triggers supported by oracle reports and their firing order.

842


What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4346


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2673


What is the difference between BPA AND Contract What are documents and test cases u followed

2174


if some data is not transfered where it will get stored

1695


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2077