Answer Posted / muzammil sabir

The report can be run from the forms in simple steps... i will show you how to run report from forms by passing a parameter to the report :
1.Create a report with the desired fields which you want to show..now go to the reports and create a user parameter named p_serial_no.
2. Then create a print button on your form and then write this code in the WHEN-BUTTON-TRIGGER of the button. I have added comments to explain the code
/*
** Declare a variable of type ParamList to store
** the Parameter list ID
*/
DECLARE
temp_id paramlist;
BEGIN
commit;
/*
** Create a Parameter list named "V_A"
*/
temp_id := CREATE_PARAMETER_LIST('V_A');
/*
** Add two Parameters to the list to pass values for each
** user-defined Parameters defined in the target form; for each
** Parameter, specify its key, type (text or data), and value
*/
ADD_PARAMETER(temp_id,'p_serial_no',text_parameter,to_number(:e_fee.fee_id,'999999999999'));
/*
** Pass a Parameter into PARAMFORM so that a parameter dialog
will not appear
** for the parameters being passing in.
*/
ADD_PARAMETER(temp_id,'paramform',text_parameter,'NO');
add_parameter(temp_id,'MAXIMIZE',TEXT_PARAMETER,'YES');
add_parameter(temp_id,'DESNAME',TEXT_PARAMETER,'PRINTER');
/*
** Run the report synchronously, passing the parameter list
*/
run_product(reports,'F:\Education\feevchr2.rdf',synchronous,runtime,filesystem,temp_id);
destroy_parameter_list(temp_id);
end;
2.A..... Replace the name of the primary key field which you have in your form or any other field in the above code where :e_fee.fee_id is written
2.B..... replace the path of the report file which you created earlier in the above code where 'F:\Education\feevchr2.rdf' is written.

................That's it when you will click the print button on form, it will invoke the report which you have created and it will be according to the field of wich you have passed the parameter..................................

What is a canvas in oracle forms?

1113

---

In what situation u create the BPA.

2248

---

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

1357

---

What do we mean by record group in oracle forms?

1129

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2185

---

What are the various configuration files that are used by oracle forms?

1073

---

What is a matrix report and how many minimum groups are required to prepare the same?

1200

---

Why oracle forms required?

1093

---

from where do u receive the information to develop report

2048

---

a text item is there what r the different types of triggers associated with it

2077

---

all steps of bitmap report?

2394

---

difference between global n context sensitive segments?

2728

---

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

2329

---

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

1500

---

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

2188

---