Search code examples
asp.netcrystal-reportsiis-6publish

Crystal report viewer is not able to display when publish to server visual studio 2010


i need to ask some question about crystal report. I have successfully run crystal report locally with visual studio 2010, But when i deploy to the server. It causes me an error.

The crystal report viewer is no able to display report .It only give me an blank page.By the way I am using window server 2003 and IIS 6.

I also has installed the crystal report run-time on my server. Did i miss any step for configure? Please guide me with some ideas. Thanks

Here is my code

 protected void Page_Load(object sender, EventArgs e)
    {

        CrystalReportViewer1.ReportSource = Server.MapPath("~/Module/Report/CrystalReport1.rpt");
    }

Solution

  • There are a couple of issues that need to be handled:

    You need to run "Verify Database" on the report again on the server if you are using SQL Server Native Client.

    These links may help further:

    Crystal reports in ASP.NET

    Crystal report error (Load report failed) in asp.net

    ** Edited ** Report not running via IIS but runs well through VS2005

    I also remember that I solved the issue after configuring Crystal Reports to run as Local Service instead of Network Service in IIS and also by using Integrated Security = True in connection string.