Skip to main content
Solved

Crystal Report doesn't load properly when use procedure in a utility package


XitIlshaS
Do Gooder (Partner)
Forum|alt.badge.img+1

Hi All

  1. Took a procedure from newly created Utility package to show data in Crystal report.
  2. done configuration properly in crystal report file as follow

Granted the new Utility package to IFSSYS and IFSPRINT using 

GRANT EXECUTE ON DEPOT_ORDER_FORECAST_UTIL_API TO IFSPRINT
GRANT EXECUTE ON DEPOT_ORDER_FORECAST_UTIL_API TO IFSSYS.

when run the report in crystal lay out data load correctly.

But when try to execute from the Application getting following error

 

When check in report log errors can see as 

"6/15/2021 8:04:24 AM[IFSCRWebSetupDEV]-[SetTableLocation] Set appropriate post-fixes for XIT_DEPOT_ORDER_FORECAST_WEEK\
6/15/2021 8:04:24 AM[IFSCRWebSetupDEV]-[SetDatabaseLocation] Generating fully qualified database object name for XIT_DEPOT_ORDER_FORECAST_WEEK\
6/15/2021 8:04:28 AM[IFSCRWebSetupDEV]-ERROR in [ExportReportWithParametersAndlogonInfo] Error in exporting the report in rpt format.
6/15/2021 8:04:28 AM[IFSCRWebSetupDEV]-The table 'XIT_DEPOT_ORDER_FORECAST_WEEK\' could not be found.
Error in File WqDepotOrderForecast_w 149024_159328_{9CF79CBA-34DB-4B1C-9EF0-8B20FCDE120B}.rpt:
The table could not be found.   at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)
   at CrystalDecisions.CrystalReports.Engine.Table.set_Location(String value)
   at Ifs_ReportService.SetDatabaseLocation(String databaseLocation, Table table) in c:\inetpub\wwwroot\IFSCRWebSetupDEV\App_Code\Service.cs:line 1409
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetupDEV\App_Code\Service.cs:line 1381
   at Ifs_ReportService.LoadReport(String path, String DBUser, String DBPassword, String DBServerName, String LogonInfoValues, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetupDEV\App_Code\Service.cs:line 1284
   at Ifs_ReportService.ExportReportWithParametersAndlogonInfo(String FileName, String WebUser, String SecuredReportRequired, String ParameterValues, String LogonInfoValues, String ExportType) in c:\inetpub\wwwroot\IFSCRWebSetupDEV\App_Code\Service.cs:line 724

Are there any thing to load the report when using Utility package procedure?

Highly Appreciate your comments and suggestions :)

Thanks & Best Regards

/Ilsha.

Best answer by ChanakaAmarasekara

Hi,

Have a look at the design guidelines from the link give below,

https://docs.ifs.com/techdocs/Foundation1/050_development/026_br_and_a/005_adhoc_reporting/080_dev_crep/005_cr_as_quickreport/default.htm#Considerations_and_design_guide_lines

 

  • PLSQL Package procedures are not supported.
    PLSQL Package procedures are not supported by the IFS reporting framework. Instead one can use Oracle Stored Procedures. If an Oracle stored procedure is used in the report, the necessary permission should be granted.

Regards,

Chanaka

 

View original
This topic has been closed for comments

3 replies

dhlelk
Superhero
Forum|alt.badge.img+15
  • Superhero
  • 200 replies
  • June 15, 2021

Ping @ChanakaAmarasekara for expert opinion.


ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15

Hi,

Have a look at the design guidelines from the link give below,

https://docs.ifs.com/techdocs/Foundation1/050_development/026_br_and_a/005_adhoc_reporting/080_dev_crep/005_cr_as_quickreport/default.htm#Considerations_and_design_guide_lines

 

  • PLSQL Package procedures are not supported.
    PLSQL Package procedures are not supported by the IFS reporting framework. Instead one can use Oracle Stored Procedures. If an Oracle stored procedure is used in the report, the necessary permission should be granted.

Regards,

Chanaka

 


XitIlshaS
Do Gooder (Partner)
Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • 3 replies
  • June 15, 2021

Hi

Thank you so much Chanaka for your support .

Best Regards

/Ilsha


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