Skip to main content
Solved

How do you get a custom report to display in Order Reports screen

  • July 16, 2021
  • 10 replies
  • 1132 views

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

How do you get a custom report to display in Order Reports screen? The custom report is defind and printable but I can not get it to be listed in the Order Report screen.  Are there specific permissions or grants to assign to the presentation objects? Any suggestions?

 

Thank you

Best answer by Randini Jayasundara

Hi @arebbeadle 

It’s good to hear that the issue has been resolved. I guess it is due to a cache refresh.

In your Report_SYS.Define_Report_(), show_in_order_reports_ has not defined hence it will set to TRUE by default. I thought it was entered as FALSE in your method call. 

When deploying operational reports, below steps need to be followed.

  1. Deploy RDF
  2. Import Schema and Layout via Report Definition screen
  3. Scan presentation objects
  4. Grant permission for relevant permission sets
  5. Refresh report cache and security cache

Thank you

This topic has been closed for replies.

10 replies

Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @arebbeadle 

Is it an operational report? If so please check the value defined for the show_in_order_reports_ parameter in the report RDF file. It must be defined inside the method call Report_SYS.Define_Report_() and the value must be set toTRUE.

 

 


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • 139 replies
  • July 19, 2021

It is an operational report.I am using IFS developer studio to generate the RDF file and I don’t see the show_in_order_reports_ parameter. Do I have to add it manually? Here is the Report_SYS.Define_Report_():

Report_SYS.Define_Report_('ARE_CUT_LIST_REP', 'SHPORD', 'AreCutList', 'Are Cut List', 'ARE_CUT_LIST_RPT', 'ARE_CUT_LIST_RPI.Execute_Report', 0);

What should it be?

Thank you,
  


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • 139 replies
  • July 19, 2021

I checked the report_sys_text_tab and the parameter is set to ‘TRUE’.

 


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • 139 replies
  • July 19, 2021

Thank you for your input but after the weekend all my custom operational reports now show in Order Reports screen. I am assuming there was some backgroud job run to refresh the report library or cache? I know Oracle was restarted twice on last friday and the reports were not showing but now they are? 

Thank you.


Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @arebbeadle 

It’s good to hear that the issue has been resolved. I guess it is due to a cache refresh.

In your Report_SYS.Define_Report_(), show_in_order_reports_ has not defined hence it will set to TRUE by default. I thought it was entered as FALSE in your method call. 

When deploying operational reports, below steps need to be followed.

  1. Deploy RDF
  2. Import Schema and Layout via Report Definition screen
  3. Scan presentation objects
  4. Grant permission for relevant permission sets
  5. Refresh report cache and security cache

Thank you


Forum|alt.badge.img+2
  • Do Gooder
  • 5 replies
  • October 15, 2021

Hi @Randini Jayasundara,

We have a custom Module and I have created a new report for this Module.

I have added the ‘TRUE’ in Report_SYS.Define_Report_, but still it does now show in Order Report.

Also, the report doesn’t appear in Presentation Object Scanning > Reports as you could see below.

 

Because of this the pres object doesn’t created automatically, thus, the report don’t appear in the Order Report.


As a workaround, I created the the pres object manually, then the report appears in the Order Report.

My questions:

  1. Why the report doesn’t show in Presentation Object Scanning > Reports?
  2. Why the pres object doesn’t create automatically?

Any ideas?


Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @rumesh 

Sorry for the late response.

Have you imported the Schema and Layout? Hope the custom module is already registered.


Forum|alt.badge.img+2
  • Do Gooder
  • 5 replies
  • November 23, 2021

Hi Randini,

I did all of that, but it is still not scanned. I did some investigation and found below.

 

 

Conclusion:

  • It seems that the framework only considers only the CORE layer when counting the reports.
  •  

  • Thus, the new reports are now shown in the Presentation Object Scanning window.

 

If you find anything regarding this issue please let me know.

Best Regards,
Rumesh


Randini Jayasundara
Superhero (Employee)
Forum|alt.badge.img+12

Hi @rumesh 

Thanks a lot for sharing your findings !

I searched bit more and found the Solution ID 285426. If your module contains new reports but doesn’t have any client screens, the issue mentioned in above solution must be the reason for not automatically generating pres objects for the reports. However I don’t think this corrects the report count issue.


Forum|alt.badge.img+2
  • Do Gooder
  • 5 replies
  • November 24, 2021

Hi Randini,

Thanks for the information :)


Best Regards,
Rumesh