What is summary column in Oracle Reports ?
Answers were Sorted based on User's Feedback
Answer / vidya sagar.g
summary columns are used to do the aggregate funtions, like
sum, avg, max...
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rajesh
for the summary feilds like grand totals we can place this
column,and it should be placed out of the repeating frame
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / 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 |
What are the triggers associated with the image item?
What is an user exit used for?
While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?
What is a Static Record Group?
Which parameter can be used to set read level consistency across multiple queries?
What are the different modals of windows?
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
What is a radio Group?
Explain the various types of oracle report?
What is the difference between bind and lexical parameter?
How can a square be drawn in the layout editor of the report writer?
Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through