Answer / tech knit

first in the main query add to parameter...
supp :deptnum is parameter
then
query...............where :deptnum or :deptnum is null

and in parameter lovs write query
after writing the query in lovs ..uncheck the check box --
'the restrict list to predetermined values'

What is the difference between setting up of parameters in reports 2.0 reports ?

1 Answers  

---

Identify package function from the following ?

1 Answers  

---

What is a predefined exception available in forms 4.0?

2 Answers  

---

What built-in is used for changing the properties of the window dynamically?

1 Answers  

---

What is the content view and stacked view?

2 Answers  

---

---

What are modal windows?

1 Answers  

---

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 Answers  

---

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

0 Answers   IBM,

---

Explain master-detail relationship with some examples.

0 Answers  

---

How many windows in a form can have console?

1 Answers  

---

Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

1 Answers  

---

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

1 Answers  

---