ASP.Net, Crystal, and premature hair loss

[RudePuppy]

Here's my problem:

 

Exception Details: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Load report failed.

 

 

Here's the source:

 

Line 40: Dim r As New CrystalDecisions.CrystalReports.Engine.ReportDocument()

 

Line 41: r.Load("\\MyServer\MyFolder\MyReport.rpt")

 

Specifically, this code ONLY fails under asp.net when the report file is located on another server. Said another way, this code always works in a vb.net app no matter where the report file is located. In asp.net, however, it only works when the file is local. That led me to think it was a permissions issue, but the following works in my asp.net app:

 

Dim r As New CrystalDecisions.CrystalReports.Engine.ReportDocument()

If IO.File.Exists("\\MyServer\MyFolder\MyReport.rpt") Then

IO.File.Copy("\\MyServer\MyFolder\MyReport.rpt", "c:\MyFolder\MyReport.rpt", True)

r.Load("c:\MyFolder\MyReport.rpt")

End If

 

 

If IO can find and copy the file, then doesn't that imply that I have handled IIS security, impersonation, and any ACL issues correctly? I'm really out of my league here, but it seems like the reportdocument object is operating under a different authorization scheme than the rest of the app.

 

Any help at all would be apreciated.

 

RudePuppy

[Robby]

At least you found a workaround for now, in the mean-time you find some help at CR ...http://support.crystaldecisions.com/library/kbase.asp?ref=default.asp_selectlist

 

Although, I searched (briefly) their site and found nothing.

[peterdoherty]

I recall having a similar problem a while ago. It was resolved by doubling up the \ in the Unc path name so \\MyServer\MyFolder\MyReport.rpt would become \\\\MyServer\\MyFolder\\MyReport.rpt.

 

I dont know whay it worked though!

 

Hope this helps.

[Disco_gal_1]

I having the same issue that rudepuppy had... neither work around seems to do the trick for me? Did you ever find a solution to this?

[eramgarden]

I had a Logon issue the other day, I posted this:

 

http://www.xtremedotnettalk.com/showthread.php?t=88590

 

the link there fixed my issue.

[Disco_gal_1]

Thanks for the links... I am wading through. Although it seems like you had an issue acessing SQL Server not the Crystal Report.

 

I am able to run the Crystal Report with no problems when I stored the report on C: but when I move the report to a server so they can be shared I get the Load Report Failed. The other strange thing is that I can access the report in a VB.Net application but not in my ASP.Net application.

 

Thanks again for the links.

 

Keri

[eramgarden]

I'd say check http://www.crystaldecisions.com