Question

Crystal Report IAL

  • 30 November 2020
  • 4 replies
  • 834 views

Badge +2

I have a custom view in the IFSINFO schema that I want to use in a form (customer Invoice). In Crystal itself the report renders correctly,  but when I generate the form in IFS I get an error “No PDF report returned from Crystal Web Service”.  

Here’s what the log looks like
 


11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword---- PrintUser-IFSPRINT PrintPassword----- DBServerName---- AppOwner-IFSAPP IALOwner-IFSINFO
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting the report in PDF format.
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] File Name : CustomerInvoiceApps10_DEV.rpt
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] ParameterValues : 1004882.0 ,LangCode = en
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[OpenReport] File Name : en\CustomerInvoiceApps10_DEV.rpt
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[OpenReport] The file C:\CWSReports\en\CustomerInvoiceApps10_DEV.rpt is found
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[LoadInfoServiceReport] Loading infoServe report : C:\CWSReports\en\CustomerInvoiceApps10_DEV.rpt
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ------- ,DBServerName : Name ,AppOwner : IFSAPP
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[LoadInfoServiceReport] Setting up logon information for each database object.
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:24 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER_LINE
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER_LINE
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : CUSTOMER_ORDER_LINE
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : CUSTOMER_ORDER
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_INFO_ADDRESS
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_INFO_ADDRESS
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : CUSTOMER_INFO_ADDRESS
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUST_ORDER_INV_ITEM_UIV_ALL
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUST_ORDER_INV_ITEM_UIV_ALL
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : CUST_ORDER_INV_ITEM_UIV_ALL
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for JT_TASK_SALES_LINE
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for JT_TASK_SALES_LINE
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : JT_TASK_SALES_LINE
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for JT_TASK_UIV
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for JT_TASK_UIV
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : JT_TASK_UIV
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for SERVICE_INVOICE_LINE_UIV
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for SERVICE_INVOICE_LINE_UIV
11/30/2020 11:05:25 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : SERVICE_INVOICE_LINE_UIV
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for NOV_WO_LE_EXPENSES_I
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[LogIALOwner] IALOwner:
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for NOV_WO_LE_EXPENSES_I
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : .NOV_WO_LE_EXPENSES_I
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.DOCUMENT_TEXT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.OUTPUT_TYPE_DOCUMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for SHIPMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for SHIPMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.SHIPMENT
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for SHIPMENT_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for SHIPMENT_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.SHIPMENT_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.CUSTOMER_ORDER_IVC_REP
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUSTOMER_ORDER_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUSTOMER_ORDER_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.CUSTOMER_ORDER_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for CUST_ORDER_INV_ITEM_UIV_ALL
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for CUST_ORDER_INV_ITEM_UIV_ALL
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.CUST_ORDER_INV_ITEM_UIV_ALL
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for JT_TASK_SALES_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for JT_TASK_SALES_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.JT_TASK_SALES_LINE
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for JT_TASK_UIV
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for JT_TASK_UIV
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.JT_TASK_UIV
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetTableLocation] Set appropriate post-fixes for SERVICE_INVOICE_LINE_UIV
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Generating fully qualified database object name for SERVICE_INVOICE_LINE_UIV
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetDatabaseLocation] Table.Location : IFSAPP.SERVICE_INVOICE_LINE_UIV
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] SubReport count : 8
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Converts any existing on-demand sub reports to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Subreport HeaderNotesSub.rpt has been converted to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Subreport ShipmentNotesSub.rpt has been converted to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Subreport OriginalInvoice has been converted to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Subreport WorkOrderGroup has been converted to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Subreport LineNotesSub.rpt has been converted to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Subreport ChargeGroups has been converted to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Subreport AdvancePaymentSub.rpt has been converted to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[ConvertOnDemandToEmbeddedSubReport] Subreport Expenses Subreport.rpt has been converted to embedded.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Result Key : 1004882 - Setting up parameters for InfoServices report.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : IFS_RESULT_KEY
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : IFS_RESULT_KEY
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER_IVC_REP.RESULT_KEY
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER_IVC_REP.RESULT_KEY
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : INVOICE_NO
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER_IVC_REP.INVOICE_NO
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER.NOTE_ID
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER_LINE.NOTE_ID
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER_IVC_REP.RESULT_KEY
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER_IVC_REP.ORDER_NO
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER_IVC_REP.RESULT_KEY
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-CUSTOMER_ORDER_IVC_REP.RESULT_KEY
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[SetInfoServiceReportParameters] Formula Form : PM-JT_TASK_UIV.REPORTED_OBJECT_ID
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 1
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 2
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 3
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 4
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 5
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 6
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 7
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 8
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 9
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Error : Missing parameter values.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[GetSavedPDFReport] Exporting report stream failed : Retry 10
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-ERROR in [GetSavedPDFReport] Error in exporting report CustomerInvoiceApps10_DEV.rpt.
11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-Missing parameter values. System.Runtime.InteropServices.COMException (0x8004100E): Missing parameter values.
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType)
at Ifs_ReportService.ExportToStream(String Operation, ExportFormatType ExportType, String FileName, String DBUser, String DBPassword, String DBServerName, String AppOwner, String IALOwner, String WebUser, String SecuredReportRequired, String ParameterValues, String LangCode, String LogonInfoValues) in c:\inetpub\wwwroot\IFSCRWebSetup_DEV\App_Code\Service.cs:line 141

IFSINFO is not be properly added on to the start of NOV_WO_LE_EXPENSES_I table.

[SetDatabaseLocation] Table.Location : .NOV_WO_LE_EXPENSES_I

I have added the output of IALOwner so I could see what it was, obviously it is null here and i dont know why

11/30/2020 11:05:26 AM[IFSCRWebSetup_DEV]-[LogIALOwner] IALOwner: 

I assume if this table was correctly generated with the IALOwner infront of it the report would render.

[SetDatabaseLocation] Table.Location : IFSINFO.NOV_WO_LE_EXPENSES_I

 

Any ideas?

 

Thanks in advance

 

 

 


This topic has been closed for comments

4 replies

Userlevel 6
Badge +13

Does IFSPRINT have access to the custom view?

Userlevel 7
Badge +15

Yes like @PRODQ mentioned the IFSPRINT user needs access to the custom view in order to resolve the issue.

Userlevel 4
Badge +8

By the error message and the description, it seems like this is an operational report.

First, create an archive entry for the report by ordering and rendering the report.

Then, open the report via Crystal Designer, and try to preview the report by providing the result key (from above archive entry). You will then be prompted to give credentials to log into the database.

Use IFSPRINT (and pwd) and check if the report shows the data.

  • If you get access errors, this is a permission issue. Check out for possible access issues
  • If you see no data, or incorrect data, it’s the RPI (report logic issue)
Userlevel 7
Badge +18

Check the suffixes on the aliases for the view names. An IAL name should end in _I or \\

IFS doesn’t recommend using other views for operational reports except the _REP views, so here’s the guide for Quick Reports showing the view suffix format:

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