Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Crystal Report Issue with IIS - ( bobj is undefined , Crystal report not displaying )

I have crystal report 2010 installed with VS 2010.i have created a crystal report which is works fine in the localhost but the issue is once i publish my website to IIS the report is never displayed.it just display a blank page.i checked my published folder even the .rpt file is not there.can any one tell me how to resolve this issue?

like image 313
chamara Avatar asked Sep 01 '11 04:09

chamara


3 Answers

Solution

The solution is to work on IIS this way:

  • Copy aspnet_client folder from c:\inetpub\wwwroot folder to the new website root folder.

or (first one is easier, second one is better for maintenance)

  • Create a virtual directory called aspnet_client that points to c:\inetpub\wwwroot\aspnet_client inside the new website

Problem analysis

It's possible to analyze the problem

  • using client tools (debug window of browser)

GET http://someserver:20080/aspnet_client/system_web/4_0_30319/crystalreportviewers13/js/crviewer/crv.js 403 (Forbidden)
GET http://someserver:20080/aspnet_client/system_web/4_0_30319/crystalreportviewers13/js/crviewer/images/style.css 403 (Forbidden)

  • or server tool (IIS log , on WIN2003 is placed in %SYSTEMROOT%\System32\LogFiles\W3SVC###\ on WIN2008 C:\inetpub\logs\LogFiles\W3SVC###).

2011-03-28 13:00:49 W3SVC701536 95.228.38.41 GET /aspnet_client/system_web/4_0_30319/crystalreportviewers13/js/crviewer/images/style.css - 20080 - 192.168.1.2 Mozilla/5.0+(compatible;+MSIE+9.0;+Windows+NT+6.1;+Trident/5.0) 403 6 64 Errore! 2011-03-28 13:00:49 W3SVC701536 95.228.38.41 GET /aspnet_client/system_web/4_0_30319/crystalreportviewers13/js/crviewer/crv.js - 20080 - 192.168.1.2 Mozilla/5.0+(compatible;+MSIE+9.0;+Windows+NT+6.1;+Trident/5.0) 403 6 64 Errore!

Cause the problem

Crystal Reports runtime is installed, but your application is not running under default web site.

  • In both cases i found that crv.js and style.css some files were not served;
  • these files are placed by CR installer in wwwroot\aspnet_client folder, but for some reasons they cannot be reached;
  • In my case the reason is that i create a different website (port 20080) and aspnet_client folder is not placed inside that website

I can see that you use different versions of software and different configurations, but i think you have the same problem.

like image 89
Emanuele Greco Avatar answered Oct 31 '22 09:10

Emanuele Greco


This problem was difficult for me to solve.

My Configuration is VS 2010, CR 14.0.2000.0 version, Window Server 2008 R2, IIS 7. I got the solution. I tried almost all solutions given in net. And I have implemented all tricks. Finally report displayed by commenting the below line in web.config.

<add key="ResourceUri" value="/crystalreportviewers13"></add>

Now am removing one by one which I installed and checking which are the things exactly required.

I tried all below:

  • Installed CR Runtime for CRRuntime_32bit_13_0_4 and CRRuntime_64bit_13_0_4.
  • Later I removed CRRuntime_32bit_13_0_4 still it works.
  • Placed the aspnet_client folder inside WWWRoot folder.
  • Placed the aspnet_client folder inside my application folder.

Restarted IIS when ever I did something.

like image 4
Antony Avatar answered Oct 31 '22 09:10

Antony


The best answer for this question is here!

http://social.msdn.microsoft.com/Forums/en-US/vscrystalreports/thread/ef56f72b-7ede-47d8-ba9e-9e63b9ac0203

  1. You need to use Web Application Project,No Website Project because Web App will combine DLL to project also.
  2. Copy C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13 (you'll got it when you install -CRforVS_redist_install_32bit_13_0.exe) To your project such as (ProjectName/crystalreportviewers13)

  3. copy this below to your web.config

3.1

<configSections>
<sectionGroup name="businessObjects">
  <sectionGroup name="crystalReports">
    <section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null" />
       <section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler" />
  </sectionGroup>
</sectionGroup>
  </configSections>

3.2

<businessObjects>
      <crystalReports>
        <rptBuildProvider>
          <add embedRptInResource="true" />
        </rptBuildProvider>
        <crystalReportViewer>
              <add key="ResourceUri" value="/crystalreportviewers13" />
      </crystalReportViewer>
      </crystalReports>
    </businessObjects>

3.4 Publish your web application with FTP Mode to your any folder,and copy this publish to your web server then TEST it!

like image 3
rochasdv Avatar answered Oct 31 '22 08:10

rochasdv