Answer / mirmaqsood123

MMB and MMX

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

0 Answers  

---

What is an Alert ?

2 Answers  

---

Explain about stacked canvas views?

2 Answers  

---

What are the various methods of performing a calculation in a report ?

1 Answers  

---

What package procedure used for invoke sql plus from sql forms ?

1 Answers  

---

---

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

0 Answers  

---

Is it possible to split the printpreviewer into more than one region?

1 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

0 Answers  

---

explain about content canvas views?

1 Answers  

---

if u develop report do u ask for anything from u r team leader

1 Answers  

---

Is it possible to insert comments into sql statements return in the data model editor?

1 Answers  

---

What is a library in Forms 4.0?

1 Answers  

---