Skip to main content
Solved

Can the notes field in Report Archive be updated?


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14

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;

 

 

Best answer by Ozgun BAL

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

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • 101 replies
  • Answer
  • August 9, 2024

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


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • 128 replies
  • August 9, 2024

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


Forum|alt.badge.img+12
  • Hero (Customer)
  • 260 replies
  • August 9, 2024
arebbeadle wrote:

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) ?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings