Answer Posted / ashutosh

just create a parameter
and write sql command in report like this...

select * from emp
where &condition

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1173

---

Is it possible to have multiple layouts in a report?

975

---

What do we mean by record group in oracle forms?

1031

---

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

1938

---

What is a canvas in oracle forms?

1026

---

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

2954

---

what are the new features introduced in oracle form services in 11g release 2?

983

---

what is tripstop report?

1774

---

How can we generate report output in excel format?

947

---

hiding item in report how like that properly,thats manually but at runtime i want to do

3159

---

what is difference between group above and group left report

3765

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

1998

---

what are bind variables?

1021

---

What is an oracle report?

999

---

if u want to delete all these detail block etc what will happen in form

1932

---