Solved

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

  • 15 June 2021
  • 3 replies
  • 569 views

Userlevel 1
Badge +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.

icon

Best answer by ChanakaAmarasekara 15 June 2021, 13:55

View original

This topic has been closed for comments

3 replies

Userlevel 6
Badge +15

Ping @ChanakaAmarasekara for expert opinion.

Userlevel 7
Badge +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

 

Userlevel 1
Badge +1

Hi

Thank you so much Chanaka for your support .

Best Regards

/Ilsha