السلام عليكم
انا عندى تقرير وكاتب فى جملة السيلكت بتاعته الاتى select invnum,itemd, invdate from dual
وكان شغال على 6i ومش عاوز يشتغل على 10gومش عارف السبب وبيظهر لى رساله خطا رقمها(41214-unable to run report)
وايضا error وهو
FRM-40738 Arugment 1 to BUILT IN SET_CUSTOM_PROPERTY CANNOT BE NULL
عاوز اعرف هل ممكن ابعت data parameterفى 10g ولا ايه وهل فى حاجه ناقصه فى هذا الكود
وده الكود اللى مكتوب عند استدعاء التقرير من الفورمه

declare

   pl_id paramlist;
   i number;
    new_row number;
 
begin go_block('MOVEMENTS_BRANCHS');
first_record;
new_row := 1;
            		 
loop

add_group_row ('myrep', END_OF_GROUP );
set_group_number_Cell ('myrep.invnum', new_row , :MOVEMENTS_BRANCHS.invnumber );
set_group_char_Cell   ('myrep.itemd' , new_row , :MOVEMENTS_BRANCHS.itemname );
set_group_date_Cell   ('myrep.invdate' , new_row , :MOVEMENTS_BRANCHS.invdate );

exit when :system.last_record = 'TRUE';	
next_record;
new_row := new_row + 1;	
END LOOP;	

             pl_id  := get_parameter_list('tempdata');
         		 
         		 if not id_null(pl_id) then
         		         		 
         		 destroy_parameter_list(pl_id);
         		 
         		 end if;
         		 
                pl_id := create_parameter_list('tempdata');	
 	
                                   add_parameter(pl_id , 'Q_1' , data_parameter , 'myrep');	 
run_report ('clienttrace1' , pl_id,'pdf');
end

;

no response

اولا "run report" مش شغالة فى ال Developer 10g - استخدم RUN_REPORT_OBJECT

المشكلة التانية الظاهر ان فى قيمة not passed صح لل SET_CUSTOM_PROPERTY
Here's some soutions for the FRM error problem
-------------------------

Checked for relevance on 06-JUN-2009

Problem
=======

FRM-40738 Argument X to builtin Y cannot be null


A.) Problems in OLE
===================


1.) Execute OLE2 code to work with english Word 97 using Spanish keywords

verb_index_str := Forms_OLE.Find_OLE_Verb(viCampoWord,'Abrir');

"frm-41345: Cannot find the verb Abrir for this server".
"frm-40738: Argument 2 to builtin EXEC_VERB cannot be null".


Solution
--------

If you specify the OLE2 instructions in Spanish, it is necesary to work with
Word 97 in Spanish.


2.) Calling OCX from Forms fails with FRM-40738 Argument 1 to bultin CALL_OLE
cannot be null on clients that have Visual Basic installed.

Solution
--------

Apply Forms 6i Patchset 14.


B.) Problems in PL/SQL


1.) FRM-40738 "PL/SQL error -- null argument to procedure not allowed."
when passing a field name to a procedure.

Solution
--------

Whenever a procedure needs a field name (e.g. SET_FIELD), the NAME should be
pass, not its content:

SET_FIELD('myfield', REQUIRED, ATTR_ON); (correct)
SET_FIELD(:myfield, REQUIRED, ATTR_ON); (wrong)


2.) FRM-40738: Argument 2 to builtin GET_BLOCK_PROPERTY cannot be null
using reserved words as variables name.

Solution
--------

When you use reserved words for declared variables, you do not get errors at
compilation time but you do get errors at runtime.

For example, the following code will give error FRM-40738:

declare
last_item varchar2(40);
begin
last_item := get_block_property('DEPT',LAST_ITEM);
end;

The above code should be changed so that last_item is not declared as a
variable:

declare
t_last_item varchar2(40);
begin
t_last_item := get_block_property('DEPT',LAST_ITEM);
end;


3.) FRM-40738: ARGUMENT 1 TO FIND_VIEW CAN NOT BE NULL execute a query
for CASE generated modules


Solution
--------

Pass valid Canvas argument to the FIND_VIEW('XX') built-in.
Remove the blank element in the list item.


Solution Description
--------------------

Since the form is generated using CASE, the standard template used by CASE
had generated default code wherin the correct argument was not passed to
FIND_VIEW().

Pass the correct Canvas name to avoid the error.


4.) FRM-40738: Argument 1 to builtin REPORT_OBJECT_STATUS cannot be null,
using Report Background Engine, not a Report Server.


Solution
--------

Use a Report Server and ensure that the Report Server name doesn't has
a Underscore in it


Solution Explanation
--------------------

If you execute run_report_object leaving report server parameter null, that is
using Report Background Engine, you get a null id as result, so
report_object_status and copy_report_object_output won't work.


5.) FRM-40738: argument 1 to built-in CLOSE_FORM cannot be null
or
FRM-40738: argument 1 to built-in GO_FORM cannot be null.

if the Form Modulename not equal the .fmx filename


Solution
--------

Argument 1 to the CLOSE_FORM and GO_FORM built-in is either the form name or
the form id.

Form Name
---------

The form name is the form module name as specified in the properties sheet.
This is NOT the name of the .fmx file that the form was saved to, which is
what the OPEN_FORM built-in uses. For example:

Name in the Form Module Property Sheet: frm40738
File Name of form executable : f40738.fmx

The following would be valid calls to these built-ins:

OPEN_FORM( 'f40738'); /* the name of the .fmx file */
GO_FORM( 'frm40738'); /* the form module name */
CLOSE_FORM( 'frm40738'); /* the form module name */

Form ID
-------

The form ID is the unique ID assigned to the form at runtime when it is
opened. Use the FIND_FORM built-in to get the value of the form id. For
example:

Name in the Form Module Property Sheet: frm40738
File Name of form executable : f40738.fmx

The following would be valid calls to these built-ins:

OPEN_FORM( 'f40738' ); /* the name of the .fmx file */
form_id := FIND_FORM('frm40738');
GO_FORM( form_id );
CLOSE_FORM(form_id);


Solution Explanation
--------------------

The name of the .fmx file is used to open forms with the OPEN_FORM, CALL_FORM
and NEW_FORM built-ins. Once the form has been opened, the form module name
is used with the GO_FORM and CLOSE_FORM built-ins. The form module name and
the file name of the form may or may not be the same.

تم تعديل 24 فبراير 201016 سنة بواسطة Om MAriam

welcome
thanks for your response
1- I have this run report in attach liberary and it done in all reports but the problem in this report that it pass data between forms and report
if 10g can pass data i want to know how i write it
thank you

ليش مافي رد؟؟؟

السلام عليكم ورحمة الله وبركاته

 

DECLARE
repid      REPORT_OBJECT;
v_rep      VARCHAR2(400);
p_list     paramlist ;
BEGIN
repid := find_report_object('AAA');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_FILENAME,getpath||'reports\'||:REP_ID);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'pdf');
p_list :=create_parameter_list('PLIST');
add_parameter(p_list,'P_NAM',text_parameter,:TITL);
add_parameter(p_list,'P_YEAR',text_parameter,:YEAR1);
add_parameter(p_list,'P1',text_parameter,:DAT1);
add_parameter(p_list,'P2',text_parameter,:DAT2);
add_parameter(p_list,'P_ACT',text_parameter,:ACT);
add_parameter(p_list,'P_TEXT',text_parameter,:PTEXT);
add_parameter(p_list,'P_NUM1',text_parameter,:NUM1);
add_parameter(p_list,'P_NUM2',text_parameter,:NUM2);
v_rep := RUN_REPORT_OBJECT(repid,p_list);
WEB.SHOW_DOCUMENT('http://127.0.0.1:8889/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repserver90','_blank');
destroy_parameter_list(p_list);
END ;

 

جزاك الله كل خير