Use the add_group_column function to add a column to record
group that was created at a design time?
Answer Posted / guest
FALSE
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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
hiding item in report how like that properly,thats manually but at runtime i want to do
Is it possible to execute a dynamic sql from forms?
List out the oracle forms configuration files?
How can we generate report output in excel format?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
i am writing a query select EmpNo from Emp how can i call in after parameter form
what is difference between group above and group left report
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
What do you understand by oracle forms and why are they required?
difference between global n context sensitive segments?
how to send file attachment from oracle forms
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
a text item is there what r the different types of triggers associated with it
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory