OraFAQ Forum: Forms » form unable to call report

Home » Developer & Programmer » Forms » form unable to call report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

form unable to call report [message #146335]

Wed, 09 November 2005 23:12

gautamvv
Messages: 254
Registered: June 2005

Senior Member

i have a form, from which i should call a report,

the report has following parameters

destype,desname,fromdate and todate.

in the form, i am calling this report from a MENU.

i attached the menu to form alright

when i click the menu, in the plsql editor, i have the following

code:

DECLARE
PARAMETER_LIST_ID PARAMLIST;

BEGIN

PARAMETER_LIST_ID:= CREATE_PARAMETER_LIST('TEMP_DATA');
ADD_PARAMETER(PARAMETER_LIST_ID,'FROM_DATE',TEXT_PARAMETER,'');
ADD_PARAMETER(PARAMETER_LIST_ID,'TO_DATE',TEXT_PARAMETER,'');

RUN_PRODUCT(REPORTS,'D:\APMC\ADDITIONAL_QUALIFICATIONS.RDF',SYNCHRONOUS,RUNTIME,FILESYSTEM,PARAMETER_LIST_ID,NULL);
DESTROY_PARAMETER_LIST(PARAMETER_LIST_ID);
END;

I am confused about add_parameter, and dont know what to send

the last argument...

my report when run, looks like this:

desname:
destype:
fromdate:
todate:

fromdate and todate are user parameters.

i am joining two tables in the sql query in the report as foll:

SELECT M.SER_NO,M.REG_NO,M.DR_NAME,D.qualification,
D.college,D.y_o_p,D.date_of_registration,D.council_name,D.reg_place FROM ADD_QUAL_MASTER M, add_qual_detail D
WHERE D.ser_no=M.ser_no and D.DATE_OF_REGISTRATION
BETWEEN :FROM_DATE AND :TO_DATE

:FROM_DATE AND :TO_DATE are the two parameters used.

but when i run the form, call the report by clicking the menu,

i get error:

frm41219: cannot call report:invalid id

and , frm-407813, argument 1 to run_report_object cannot be null.

should i use two extra add_parameter statements for
destype and desname also?

when i run the report, you can see sample of parameters in the
file uploaded.

thanks