Skip to main content

Can the notes field in Report Archive be updated? We have custom reports that show up in report archive and we need to know if the Notes field can be updated?

Here is the RMB menu code we used to print:

DECLARE
result_key_ Number; 
pr_attr_ varchar2(2000); 
attr_ varchar2(2000);
report_id_ varchar2(2000);
job_id_ number; 
par_attr_ varchar2(2000);

begin 
report_id_ := 'ARE_PART_ORDER_INFO_TAG_REP';
Client_SYS.Add_To_Attr('PRINTER_ID', 'MA1WINDOOR',pr_attr_);
Client_SYS.Add_To_Attr('EXPIRE_DATE',sysdate+30,pr_attr_);
Print_Job_API.New(job_id_,pr_attr_);
Client_SYS.Add_To_Attr('REPORT_ID',report_id_,pr_attr_);
Client_SYS.Add_To_Attr('LAYOUT_NAME', 'RearDoor4x6Lbl_P65A.rpt', pr_attr_);
Client_SYS.Clear_Attr(par_attr_);
Client_SYS.Add_To_Attr('CONTRACT', &CONTRACT,par_attr_);
Client_SYS.Add_To_Attr('ORDER_NO', &ORDER_NO,par_attr_);
Client_SYS.Add_To_Attr('REL_NO', &RELEASE_NO,par_attr_);
Client_SYS.Add_To_Attr('LINE_NO', &SEQUENCE_NO, par_attr_);
Archive_API.New_Instance(result_key_,pr_attr_,par_attr_);
Client_SYS.Clear_Attr(attr_);
Client_SYS.Add_To_Attr('PRINT_JOB_ID', job_id_, attr_);
Client_SYS.Add_To_Attr('RESULT_KEY', result_key_, attr_);
Print_Job_Contents_API.New_Instance(attr_);
Print_Job_API.Print(job_id_);
END;

 

 

Dear @arebbeadle ,

 

It has been a year, maybe you solved that problem, 

But I found a solution about your issue like below;

 

please use RMB on the lines to add expression list or property list  etc.

 

 

Hope it helps!

Özgün Bal


Thank you @Ozgun BAL , I will try and let you know.


Can the notes field in Report Archive be updated? We have custom reports that show up in report archive and we need to know if the Notes field can be updated?

Here is the RMB menu code we used to print:

DECLARE
result_key_ Number; 
pr_attr_ varchar2(2000); 
attr_ varchar2(2000);
report_id_ varchar2(2000);
job_id_ number; 
par_attr_ varchar2(2000);

begin 
report_id_ := 'ARE_PART_ORDER_INFO_TAG_REP';
Client_SYS.Add_To_Attr('PRINTER_ID', 'MA1WINDOOR',pr_attr_);
Client_SYS.Add_To_Attr('EXPIRE_DATE',sysdate+30,pr_attr_);
Print_Job_API.New(job_id_,pr_attr_);
Client_SYS.Add_To_Attr('REPORT_ID',report_id_,pr_attr_);
Client_SYS.Add_To_Attr('LAYOUT_NAME', 'RearDoor4x6Lbl_P65A.rpt', pr_attr_);
Client_SYS.Clear_Attr(par_attr_);
Client_SYS.Add_To_Attr('CONTRACT', &CONTRACT,par_attr_);
Client_SYS.Add_To_Attr('ORDER_NO', &ORDER_NO,par_attr_);
Client_SYS.Add_To_Attr('REL_NO', &RELEASE_NO,par_attr_);
Client_SYS.Add_To_Attr('LINE_NO', &SEQUENCE_NO, par_attr_);
Archive_API.New_Instance(result_key_,pr_attr_,par_attr_);
Client_SYS.Clear_Attr(attr_);
Client_SYS.Add_To_Attr('PRINT_JOB_ID', job_id_, attr_);
Client_SYS.Add_To_Attr('RESULT_KEY', result_key_, attr_);
Print_Job_Contents_API.New_Instance(attr_);
Print_Job_API.Print(job_id_);
END;

 

 

 

Updated/Generated at the moment of print/creation, or updated AFTER it already exists in the Report Archive (i.e. CHANGING the notes of an existing archive entry) ?


Reply