Why is that my reports won't load in Windows 7 but in Windows XP I got no problem?

[josin]

Here are the tools that i'm using:

Visual Studio .Net 2003
Crystal Report 8.5
OS: Windows XP

I have developed a visual basic application running in windows xp. My program works fine, all reports will appear. But when I installed my program in windows 7, I got this error "Load report failed." during viewing of reports.

Any idea will greatly appreciated. Thank you so much.

Here's my code:

Try
            oRPT = New ReportDocument
            sReportDir = Application.StartupPath + "\Rpt"
            sReportDir = sReportDir.Replace("\", "\\")
            sReportDir = Trim(sReportDir) + "\\rptInventoryReport2.rpt"
            oRPT.Load(sReportDir)
            With crConnectionInfo
                .ServerName = sSQLServer
                .DatabaseName = sDB
                .UserID = sSA
                .Password = sSApass
            End With
            Pause(3)
            crTables = oRPT.Database.Tables
            crtableLogoninfo.ConnectionInfo = crConnectionInfo
        crTables.Item("vw_Inventory2").ApplyLogOnInfo(crtableLogoninfo)
            crTables.Item("vw_Inventory2").Location = sDB + ".dbo.vw_Inventory2"

            oRPT.SetParameterValue("pDate", Trim(frmInventoryItems.txtFilterDate.Text))
            oRPT.SetParameterValue("Employee", Trim(sEmployeeName))
    
            ReportViewer.ReportSource = oRPT
            ReportViewer.RefreshReport()

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

[TamusJRoyce]

Does upgrading to .Net 2005 help? vs 2003 .net isn't supported anymore and is widely known as a failure.

I would have a .Net 1.1 legacy version, and .NET 2.0 version (at least 2.0) if this fixes the issue.

I also know things like the JET driver has been depreciated. So maybe something like that has been updated within the reporting framework to support Windows 7 by version 2.0. May have to try 3.5, too?

[josin]

Thank you so much for the idea TamusJRoyce.

[Sendy Santoso]

Maybe the problem lies on the different IIS version.
Windows XP using IIS 6 and Windows 7 using IIS 7.

Maybe you can try this :
1. Make sure you add permission to windows temporary folder depend on your IIS user
2. Install the right redistributable crystal report version
3. Changing identity on app pool to 'Network Services'

Reference : Crystal Report Load Report Failed when deployed in IIS

hope this helps.