Hi All
- Took a procedure from newly created Utility package to show data in Crystal report.
- 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]-VSetTableLocation] Set appropriate post-fixes for XIT_DEPOT_ORDER_FORECAST_WEEK\
6/15/2021 8:04:24 AM IFSCRWebSetupDEV]-VSetDatabaseLocation] Generating fully qualified database object name for XIT_DEPOT_ORDER_FORECAST_WEEK\
6/15/2021 8:04:28 AM IFSCRWebSetupDEV]-ERROR in iExportReportWithParametersAndlogonInfo] 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.