Interested to Buy Any Domain ? << Click Here >> for more details...
What is summary column in Oracle Reports ?
- 5 Answers
- 17558 Views
- GE, I also Faced
- E-Mail Answers
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 ERASE package procedure does ?
Can you change the alert messages at run-time?
what is the source file of po report?
What are the different types of Delete details we can establish in Master-Details?
I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent
BY SELECT * FROM EMP QUERY ,I GENERATED ONE REPORT.AND SUPPOSE THAT I HAVE 10 PAGES OF OUTPUT. WHAT I WANT IS ,I WANT TOTAL PER EACH PAGE.OK I GOT THAT AND THAT SHOULD BE FORWARDED TO NEXT PAGE AND NEXT PAGES TOTAL SHOULD BE DISPLAYED
Which of the above methods is the faster method?
what is the diffrence between before parameter form triger & formate trigger
What does the term panel refer to with regard to pages?
What is the remove on exit property?
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,
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
Oracle General 
