August 16, 2012

Crystal Report doesn't show after some time

If application is in live environment and built using .Net Framework 4.0 along with SQL Server 2008 R2 database. Sometimes problem is rising when crystal report viewer doesn't able to show me on page. No matter how many times you reset iis server or clear sessions. Another weird thing that other pages behave fine with tables from which crystal reports pick the data working perfectly while crystal report doesn't.

One important link to resolve that issue is mentioned below.

http://forums.asp.net/t/1559602.aspx/1?Report+doesn+t+show+after+some+time

Sometimes this link will not help certain peoples, they also mentioned error "Report Load Failed", but if Exception is raising from method means its something is cooking there weird but why that exception not raised when any user hit different reports several time???

The simple solution for above mention issues are :
  1. Please make sure the crsytal report version that you used on your code MATCHES the one you instal on the server.
  2. Please make sure the crsytal report assemblies that you used on your code MATCHES the one you instal on the server.
  3. Please make sure you allow FULL TRUST mode on your site/application.
  4. Please make sure you set the application pool to run under LOCAL SERVICE permission.
  5. Please make sure you copy the crystalreportviewer folder to your working folder.
  6. Please make sure your server has enough RAMs to run Crystal Report.

2 comments:

  1. SAP

    Our network of IT professionals bring together the expertise to address IT related issues for SMEs. If we cannot provide you with help with your problem, we will do our utmost to point you in the right direction.
    We employ a consultative approach to ensure that all your requirements are met in a timley mannor and within budget. Website: www.thesmartoffice.ie

    ReplyDelete
  2. Crystal Reports

    The Smart Office provides IT services to SMEs in the form of Business Intelligence (SAP Business One), Business Analysis, E-Commerce, IT Consultancy and informational Web Design. For more information then visit - Website: www.thesmartoffice.ie

    ReplyDelete