Oracle Forms Reports Interview Questions
Questions Answers Views Company eMail

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 3917

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1749

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

1477

in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........

1 3813

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 4608

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

1909

how to eliminate duplictes in column except group and section?

iFlex, TCS,

2 6547

How can we expand Parameter Form Canvas on Reports 6i?

ABB,

2177

How the Action Trigger works? and what is full syntex of srw.run_report?

CMC, Yantro Software,

1 8543

what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)

IBM, Oracle,

1 23180

Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 3121

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

1 3313

I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....

4 5717

HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT QUERY OR MULTIPLE GROUP QUERY ?

Jaguar, TCS,

1 13648

How can we call a URL from a menu (Oracle Forms 6i)?

2 10838


Post New Oracle Forms Reports Questions

Un-Answered Questions { Oracle Forms Reports }

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2073


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1064


HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1281


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

2880


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...

1936


what exactly u write in when_new_form_instance

3196


why the Ctl file u put only in bin folder why not in other folder

1828


what is difference between group above and group left report

3592


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

1774


how do u place it in required folder

1695


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

2717


What do you understand by oracle forms?

810


How can we expand Parameter Form Canvas on Reports 6i?

2177


what are bind variables?

813


Is it possible to execute a dynamic sql from forms?

821