Skip to Content
avatar image
Former Member

Charts/images not showing in report viewer VS 2008 CR Basic

Hi, we currently have the same Visual Studio 2008 Crystal Reports Basic 2008 asp.net web application running on three servers. Two of these servers, which are development/uat, display images and/or graphs on reports in the crystal report viewer fine but the third, which is our production box, displays the red X for all charts/images. We have reviewed/updated the web.config file as per resources listed below. Here is our system configuration and what we have done/verified so far:

Windows Server 2003 32 bit Service Pack 2

IIS 6

Crystal Reports Basic Runtime for Visual Studio 2008

Microsoft .NET Framework 3.5 SP1

We have reviewed and verified the information provided by the u201CCrystal Report Viewers in Visual Studio .NET Dynamic Imagesu201D as it pertains to the section u201CUsing Crystal Reports Basic (version 10.5 bundled with Microsoft Visual Studio .NET 2008)u201D.

We have verified the security settings on the C:\windows\temp folder across all three servers.

We have verified all setting in iis for the web site across all three servers.

We can see the u201C.pngu201D files getting created in the C:\windows\temp\ cr_tmp_image_ folder on the production server.

We have verified the image path is correct utilizing the CrystalImageHandler.aspx.

We have verified that the assemblies exist in the c:\widows\assembly folder

Exporting the reports as PDFs produces the charts and images fine so it appears to be a report viewer control issue.

This production box originally had a Visual Studio 2003 asp.net application on it using, we think, crystal report viewer 11.5 (CrystalDecisions.Web 11.5.3300.0), if that makes a differenceu2026

Right now we are at a loss, we have reviewed all help files we can locate on this issue and still have not been able to resolve. Any insight on something we may have missed or could try next would be appreciated.

Thanks for your time.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 08, 2010 at 06:16 PM

    The only thing I can think of at this time would be the registry (looks like you've done everything else...)

    Look for these keys:

    HKLM\SOFTWARE\Business Objects\10.5\Crystal Reports.

    Look for ChartSupportPath, CommonFiles and Path.

    Make sure you are not installing "aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer4/..." files under "wwwroot\abc\". THis will not work with CR 10.5.

    Also, give u201CIIS_WPGu201D access to the u201CSystemu201D user or u201CNetwork Serviceu201D (whichever account your app pool uses)

    Ludek

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for your reply. Actually I ran across those articles you linked and already tried the recommended steps. I believe you in your assertion that it can work and all co-exist. My complaint and frustration is the manual working around that is required in order to achieve this. Out of the box these solutions should work a lot cleaner than what is currently the case. I suppose that development tools are allowed to fall into this trap because it's assumed that developers are techies and can just figure it out. Imagine if the endusers we are creating these reports for were expected to follow suit?

      In the interim I have abandoned the dynamic image links as provided out of the box in CR, and have worked around the matter differently in my reports. It works, is a bit ugly, but is the best I can do after spending roughly 6 hours trying to research and plug away to no avail...

  • Mar 08, 2010 at 03:02 PM

    A few ideas;

    Make sure IIS is not set up to use framework 1.1

    Run [Modules|https://smpdl.sap-ag.de/~sapidp/012002523100006252802008E/modules.zip] and compare dlls loading on one of the good servers and the server that gets the red x.

    Run [Process Monitor|http://technet.microsoft.com/en-ca/sysinternals/bb896645.aspx] and see if it gives you any indication of what is going on

    Run the [Charles|http://www.charlesproxy.com/download.php] utility and see if that gives you any clues.

    Ludek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2010 at 01:27 PM

    Hi,

    I managed to resolve our issue with the images displaying as a red u201Cxu201D on our production server. Basically what I did was walk through IIS with the server that was displaying the images, the u201Cgoodu201D box, vs. the one that wasnu2019t, the u201Cbadu201D box. Here is what I changed/added:

    The permissions of the default app pool on the u201Cbadu201D box, in IIS, was missing some accounts: u201CIIS_WPG (<servername>\IIS_WPG)u201D and u201CInternet Guest Account (<servername>\IUSER_<servername>)u201D. I added these with the same permissions as was on the u201Cgoodu201D box.

    The next changes were done to the default app pool in properties -> home directory -> configuration. There was a bunch of extensions missing from the u201Cbadu201D box so I went through line by line and manually added using the u201Cgoodu201D box as a reference. Once done, I recycled the default app pool and the issue was resolved.

    I hope this may help anyone else that may have a similar issue. Our set up: Widows Server 2003 SP2, IIS 6.0, .NET versions 1.1, 2.0, 3.0 SP2, and 3.5 SP1 installed.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      the correct path in IIS should be: default web site -> home directory -> configuration

      here is the list.. hope it helps...

      Cache ISAPI Extensions (checked)

      Extension .ad -

      executable: c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .adprototype - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .asa - C:\WINDOWS\system32\inetsrv\asp.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .asax - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .ascx - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .ashx - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .asmx - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .asp - C:\WINDOWS\system32\inetsrv\asp.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .aspx - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .axd - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .browser - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .cd - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .cdx - C:\WINDOWS\system32\inetsrv\asp.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .cer - C:\WINDOWS\system32\inetsrv\asp.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .compiled - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .config - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .cs - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .csproj - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .dd - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .exclude - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .idc - C:\WINDOWS\system32\inetsrv\httpodbc.dll

      Limit to: GET,POST

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .java - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .jsl - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .ldb - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .ldd - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .lddprototype - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .ldf - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .licx - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .master - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .mdb - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .mdf - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .msgx - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .refresh - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .rem - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .resource - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .resx - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .rules - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .sd - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .sdm - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .sdmDocument - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .shtm - C:\WINDOWS\system32\inetsrv\ssinc.dll

      Limit to: GET,POST

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .shtml - C:\WINDOWS\system32\inetsrv\ssinc.dll

      Limit to: GET,POST

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .sitemap - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .skin - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll\

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .soap - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .stm - C:\WINDOWS\system32\inetsrv\ssinc.dll

      Limit to: GET,POST

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .svc - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .vb - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .vbproj - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .vjsproj - c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .vsdisco - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)

      Extension .webinfo - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (checked)

      Extension .xoml - C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

      Limit to: GET,HEAD,POST,DEBUG

      Script Engine (checked)

      Verify that file exists (unchecked)