locked
Invalid Report Path On hosting RRS feed

  • Question

  • User1406973109 posted

    Hi All,

    Please i need some help, i've hosted my web application and everyother works fine except the crystal report bringing this error of invalid report file path.

    It works fine on the development machine, but on hosting, it does not.

    This is the error its bringing online:

    Invalid report file path.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
    Exception Details: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Invalid report file path.
    Source Error:

    Line 98: 
    Line 99:     Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo, ByVal myReportDocument As ReportDocument)
    Line 100: Dim myTables As Tables = myReportDocument.Database.Tables Line 101:        For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myTables
    Line 102:            Dim myTableLogonInfo As TableLogOnInfo = myTable.LogOnInfo

    Source File: E:\HostingSpaces\atfadbti\mmsbip.com.ng\wwwroot\App_Code\ApplicationGlobalConstants.vb    Line: 100
    Stack Trace:

    [LoadSaveReportException: Invalid report file path.]
       CrystalDecisions.CrystalReports.Engine.EngineExceptionUtils.DoThrowException(String message, EngineExceptionErrorID id) +60
       CrystalDecisions.CrystalReports.Engine.ExceptionThrower.ThrowEngineException(String messageID, EngineExceptionErrorID id) +294
       CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) +291
       CrystalDecisions.CrystalReports.Engine.ReportDocument.EnsureLoadReport() +157
       CrystalDecisions.CrystalReports.Engine.ReportDocument.get_Database() +77
       ApplicationGlobalConstants.SetDBLogonForReport(ConnectionInfo myConnectionInfo, ReportDocument myReportDocument) in E:\HostingSpaces\atfadbti\mmsbip.com.ng\wwwroot\App_Code\ApplicationGlobalConstants.vb:100
       ApplicationGlobalConstants.GetReportConnection(ReportDocument objReports) in E:\HostingSpaces\atfadbti\mmsbip.com.ng\wwwroot\App_Code\ApplicationGlobalConstants.vb:95
       ReportDialogs_WatchDog_Default.Page_Load(Object sender, EventArgs e) in E:\HostingSpaces\atfadbti\mmsbip.com.ng\wwwroot\ReportDialogs\WatchDog\Default.aspx.vb:248
       System.Web.UI.Control.OnLoad(EventArgs e) +132
       System.Web.UI.Control.LoadRecursive() +66
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428
    
     
    Please what can i do.
     
    Thanks
    Tim
    Monday, March 25, 2013 5:10 AM

Answers

  • User1406973109 posted

    Well, i was able to resolve the problem by using a 64 bit system to create the crystal reports

     

    Thanks

     

    Tim

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 9, 2013 5:50 AM

All replies

  • User1406973109 posted

    Sorry to add, this is the code that calls the report:

    Private Sub LoadTelevisionAllZoneReport()
            Try
                strReportPath = Server.MapPath("~/Reports/crpWatchDogTelevision.rpt")
                objReports.Load(strReportPath)
    
                objAdvertizerParam = objReports.ParameterFields("@AdvertizerId")
                objBeginDateParam = objReports.ParameterFields("@BeginDate")
                objEndDateParam = objReports.ParameterFields("@EndDate")
                objBrandParam = objReports.ParameterFields("@Brand")
                objIdentifierParam = objReports.ParameterFields("@Identifiers")
                objStationsParam = objReports.ParameterFields("@Stations")
    
                objAdvertizerParam.CurrentValues.AddValue(Session("ClientId"))
                objBeginDateParam.CurrentValues.AddValue(BeginDate)
                objEndDateParam.CurrentValues.AddValue(EndDate)
    
                Dim objBrandValues As ParameterValues = New ParameterValues()
                For Each item As Object In objBrandLists
                    Dim objDiscreteValue As ParameterDiscreteValue = New ParameterDiscreteValue()
                    objDiscreteValue.Value = item.ToString
                    objBrandValues.Add(objDiscreteValue)
                Next
                objBrandParam.CurrentValues = objBrandValues
    
                Dim objIdentifiersValues As ParameterValues = New ParameterValues()
                For Each item As Object In objBrandIdentifierLists
                    Dim objDiscreteValue As ParameterDiscreteValue = New ParameterDiscreteValue()
                    objDiscreteValue.Value = item.ToString
                    objIdentifiersValues.Add(objDiscreteValue)
                Next
                objIdentifierParam.CurrentValues = objIdentifiersValues
    
                Dim objStationsValues As ParameterValues = New ParameterValues()
                For Each item As Object In objStationsLists
                    Dim objDiscreteValue As ParameterDiscreteValue = New ParameterDiscreteValue()
                    objDiscreteValue.Value = item.ToString
                    objStationsValues.Add(objDiscreteValue)
                Next
                objStationsParam.CurrentValues = objStationsValues
    
                CrystalReportViewer1.ReportSource = objReports
    
    GetReportConnection(objReports)
    
            Catch ex As Exception
    
            End Try
        End Sub

    Thanks

    Tim

    Monday, March 25, 2013 5:15 AM
  • User1406973109 posted

    I contacted the hosting company, i was told that the hosting platform is crystal reports 2008 x64, i don't know which version i'm running, but actually, i'm using visual studio 2008 sp1 and my crystal report version is 10.5.3700.0 and i checked i can see that crystal report runtime x64 is installed on my system.

    Please how can i configure my website to target x64 crystal report

     

    Thanks

    Tim

    Tuesday, March 26, 2013 12:45 PM
  • User1406973109 posted

    Well, i was able to resolve the problem by using a 64 bit system to create the crystal reports

     

    Thanks

     

    Tim

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 9, 2013 5:50 AM