How can a button be used in a report to give a drill down
facility?
Answer Posted / guest
By setting the action associated with button to Execute
pl/sql option and using the SRW.Run_report function.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how do u compile a form i.e .fmb file in Unix or in dos
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
What is an oracle report? List its various types.
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
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
hiding item in report how like that properly,thats manually but at runtime i want to do
what are the oracle forms services components include?
Name the different triggers associated with oracle forms having a master-detail relationship.
What do you understand by oracle forms and why are they required?
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
Explain how one can iterate through items and records in a specified block?
what is oracle forms?
how report can be generated if we have the database designed in oracle 10g?
a text item is there what r the different types of triggers associated with it