Error "The system cannot find the path specified" on ASP .NET 2.0 webform based report.

Hi All,

I'm hoping someone will know the answer to this because its been driving me crazy for days.

I've built my first Crystal Report in VS 2005 and attached it to a WebForm using a ReportViewer control. Its working fine on my development pc but the page won't load on the webserver once deployed.

Heres the code from the code behind page:

Dim reportPath As String = Server.MapPath("myReport.rpt")

WebReport = New ReportDocument

WebReport.Load(reportPath)

I've installed the Crystal redistributables from the merge modules on businessobjects.com on the server and I've checked the access permissions on the files and that looks ok too.

Any ideas Please!

Thanks

Keith

BTW.... heres the error message:

Server Error in '/CPP' Application.

Answer this question

Error "The system cannot find the path specified" on ASP .NET 2.0 webform based report.

  • schallm

    THis is a security issue. To Resolve this either place your rpt files in c:\ or in c:\intpub folder.



  • Brian Shepherd

    I have what appears to be the same problem as you. Did you ever find a solution

    Thanks,

    Therese


  • Vidhan

    I am not sure but such things happen when appropriate rights are not assigned.Assign appropriate right to ASP.NET account and other accounts used in web application
  • steve hallden

    yes i WEBSERVERNAME/ASPNET account is even on administrators group.

    i also tried using the merge module and followed the instructions but it is giving me an error of "global.asax.vb" not found.

    i am using the vs2005 asp.net web application project... not the asp.net web site project.


  • Kevin E

    You shouldn't specify the path hardcoded like that. I would suggest on using Server.MapPath("Filename.rpt") which goes from where your application is running from.
  • sophia james

    After a loooooong struggle I managed to solve the problem.

    I also upgraded from 2003 with crystal 11 to 2005 without crystal 11 (bugger).

    So now its Crystal 10 with asp.net 2005 (since crystal 11 sp1 is not compatible, sp2 i presume its a one gig download or so it seems, but free).

    The code I am using is as follows:

    Dim rptDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument

    rptDocument.Load(Server.MapPath("cryLetterhead.rpt"))

    CrystalReportViewer1.ReportSource = rptDocument

    this is not the only thing that is required.....

    If you have sql 2005 installed you will need to configure you app to be able to connect to the database and create its user roles etc. So make sure that in your machine.config (do a search but make sure its for framework 2.0 not 1.1) file has the following lines:

    <connectionStrings>
    <add name="LocalSqlServer" connectionString="Data Source=SERVERNAME;Initial Catalog=aspnetdb;Integrated Security=True" providerName="System.Data.SqlClient" />
    </connectionStrings>

    SERVERNAME = YOUR SERVERNAME

    Initial Catalog MUST be aspnetdb

    Then from Visual Studio (in the project you are working on), check your solution explorer, on the top right is a icon which says "ASP.Net Configuration" when you hover your mouse over it. Open it. On the home page, click on security.

    There should be three options: Users, Roles, Access Rules. If you don't see them, it means the connection to the Database has not been successfull.

    Under Access Rules click on Create Access Rules. Now on the left, select the folder where the report is stored in and create a rule for "all users", and "anonymous users" with "Allow" Permission. That worked for me.

    I tried it on the root directory of my web page but it did not work. I am using a local intranet with not such a hectic security issue, so "all users" and anonymous users" is sufficient. You might consider setting up users etc in a more secure network.

    Hope this was usefull



  • JimGries - MSFT

    ok i'm having the same problem as the above. i'm using a server.mappath("filename.rpt") but it is still not working...

    alternatively, i've also done the crystal reports deployment thru merge module but it produced an error that it cannot find the global.asax when i tried to view the deployed web project.

    need help. thanks.


  • Error "The system cannot find the path specified" on ASP .NET 2.0 webform based report.