Answer / guest

1. Perform the calculation in the SQL statements itself.
2. Use a calculated / summary column in the data model.

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

0 Answers  

---

What are the different file extensions that are created by oracle reports?

1 Answers  

---

Can we use bulk collect in oracle forms if yes then how?

1 Answers  

---

Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??

1 Answers  

---

How to create Drill down report?

0 Answers   ABB, ESS, Infosys,

---

What does an on-clear-block Trigger fire?

1 Answers  

---

in before report trigger SRW.user_exit(FND_Userinit) what will do

3 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  

---

How to create LOV in Oracle forms?

2 Answers   Accenture, Polaris,

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

0 Answers  

---

What is synchronize?

2 Answers  

---

What is lexical parameter ?

2 Answers   Zensar,

---