CR viewer fails to render page when reports are having charts and images

[Former Member]

Hi all,

We have created an ASP.Net application with CR 10 using VS.Net 2005. It is working fine on dev machines. We are facing some issues when we deployed this application on windows 2008 server(IIS 7.0). And also, some of the reports working fine which are not having images.

We are facing the problem with reports having images in them and charts in their subreports.

When we run these reports on browser we are getting the following error with yellow background.

"Error: Fail to render the page".

Can anybody please let me know the solution for this issue?

Thanks,

Nagaraju.K

[former_member183750 · Accepted solution]

More information needed.

1) What is the version of the CR assembly crystaldecisions.crystalreports.engine.dll referenced in your project?

2) How do you deploy the CR runtime? / What is the name of the msm or msi used?

Ludek

[Former Member · Accepted solution]

Hi Ludek,

Thank you for your response.

Please find below the details of CR.Net we are using on windows 2008.

1. CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0

2. We have installed CRRedist2005_x86.msi on windows 2008.

Some of the reports in my asp.net application are working fine but only issue with reports having images and charts in subreports.

Please help me to resolve this issue.

Thanks,

Nagaraju.K

[former_member183750 · Accepted solution]

I believe the info in this [Article|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0437ea8-97d2-2b10-2795-c202a76a5e80]

Ludek

[Former Member · Accepted solution]

Hi Ludek,

Thank you for your response. I have added the following tags in web.config file and it is working fine in windows XP. But still it is not working in windows 2008(IIS 7.0). And also, I gave all privileges on temp folder to all the users in the system.

<appSettings>

<add key="CrystalImageCleaner-AutoStart" value="true"/>

<add key="CrystalImageCleaner-Sleep" value="60000"/>

<add key="CrystalImageCleaner-Age" value="120000"/>

</appSettings>

<httpHandlers>

<add verb="GET" path="CrystalImageHandler.aspx"; type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

</httpHandlers>

If I run my asp.net app on Windows 2008, I am able to see CR toolbar in browser but charts and images are not displaying and giving "Failed to render the report" with yellow background.

Please let me know whatelse I am missing to resolve this issue.

Thanks,

Nagaraju.K

Edited by: Nagarajukt on Mar 10, 2009 8:00 AM

[former_member11696 · Accepted solution]

Moving this post to our .NET forum, this is not legacy development.

[former_member183750 · Accepted solution]

I believe the WIN 2008 may be the issue here. CR 10.2 is not supported on Win 2008. See the follwoing wiki:

https://www.sdn.sap.com/irj/scn/wiki?path=/display/bobj/crystalReportsforVisualStudio.NETRuntimeDistribution-Versions9.1to12.0

I can't find the release notes for CR 10.2 at this time, but I'm sure Server 2008 will not be listed there.

Now, we can try to lick this one a bit, but eventually, you may want to consider upgrading to CR 2008 which is supported on Win 2008. One question and one suggestion:

Are you installing under a default website, or a custom website?

See if the utility Process Monitor will help. ProcMon is [here|http://technet.microsoft.com/en-ca/sysinternals/bb896645.aspx]. Filter it for your process before running it as it tends to make large files. Once you have a log, look for "Access Denied" or any other exception messages.

Ludek

[daniel_paulsen · Accepted solution]

two things to try here...

1. Run the application pool used by the application in a "Classic" pipeline mode rather than "Integrated"

2. take all of the information in your <httpHandlers>...</httpHandlers> tags and copy them into <handlers>...</handlers> tags. The <handlers> tags have to exsist between <system.webServer>...</system.webServer> tags whereas the httpHandlers have to exist between <system.web> tags. This is an IIS7 feature. With the CrystalImageHandler specified within <handlers> tags you should be able to see images using the Integrated pipeline mode in your app pool

since Windows 2008 released well after VS2005, there's no guarentees, but the final web.config might have something similar to the following:

<system.webServer>

<validation validateIntegratedModeConfiguration="false"/>

<modules>

<remove name="ScriptModule"/>

<add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</modules>

<handlers>

<add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode"/></handlers>

</system.webServer>

dan

[former_member183750 · Accepted solution]

I also found this thread where apparently someone was successful in getting CR 10.2 to run on server 2008:

Ludek

BTW., please let us know if any of the suggestions help. It will be nice to make a note on this in our notes database.

Edited by: Ludek Uher on Mar 10, 2009 9:59 AM

[Former Member · Accepted solution]

Hi all,

Thank you for your response.

I have the following tags in my web.config file used.

<system.web>;

<httpHandlers>

<add verb="GET" path="CrystalImageHandler.aspx"; type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

</httpHandlers><httpModules>

<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>

</httpModules>

</system.web>;

Sorry for the confusion.

Crystal reports in my application are working fine with Win 2008 but only issue with reports having charts and images. I am able to see all other reports except the reports having images and charts.

Thanks,

Nagaraju.K

[Former Member · Accepted solution]

Hello all,

We are using CR XI.5 and we are having the exact issue in Win 2008 (.Only the reports with graphs is throwing the error 'Error:Fail to render page' . The other reports, even the one with dynamic logo is working fine.We have tried giving access to temporary folder to the network user and the following is our entry in Web.Config file in<system.Webserver> <Handlers> section.

<add name="CrystalImageHandler.aspx_GET" path="CrystalImageHandler.aspx" verb="GET" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode,runtimeVersionv2.0" />

We are held up due to this issue and unable to release our installer to our client who has been waiting since long. Any help would be much appreciated.Please let me know if you require further details.

Thanks and Regards,

Vaneeth

[daniel_paulsen · Accepted solution]

If you have the AppPool set with ManagedPipelineMode=Integrated (instead of classic) you need to move the handlers to system.webServer. The easiest solution is to run the AppPool in "Classic" mode.

Quote from [this link|http://msdn.microsoft.com/en-us/library/bb763179.aspx]

Some settings in the system.webServer section apply only to IIS 7.0 Integrated mode and do not apply to Classic mode. In particular, any managed-code modules and handlers specified in the system.WebServer section of the Web.config file are ignored if the application is running in Classic mode.

Dan

[Former Member · Accepted solution]

Hi Vaneeth,

I got the crystal report problem solved by installing Crystal Report 2008. Their is no other ways. You don't need to convert the crystal reports done in 10.0.3600.0 to crystal report 2008, the only thing you have to do is

After installing Crystal Report 2008 make changes in the web config like this

<compilation debug="true">

<assemblies>

<add assembly="CrystalDecisions.CrystalReports.Engine, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.ReportSource, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Shared, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Enterprise.Framework, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

</assemblies>

</compilation>

You need to change in http handler section also

<httpHandlers>

<add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

</httpHandlers>

After making these changes the next step is you have to change the web form from where the report is calling

ie,

<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"

Namespace="CrystalDecisions.Web" TagPrefix="CR" %>

Change it to

<%@ Register Assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"

Namespace="CrystalDecisions.Web" TagPrefix="CR" %>

Remember that DisplayGroupTree option will not support in source for CR 2008

So if any thing exists you should remove that thing like

<cr:crystalreportviewer id="crvPayGraph" runat="server" autodatabind="true" DisplayGroupTree="False" EnableDrillDown="False" OnDataBinding="crvPayGraph_DataBinding"></cr:crystalreportviewer>

You should omit that part DisplayGroupTree="False"

Instead you can provide it in the code section as

crvPayGraph.DisplayGroupTree=false;

crvPayGraph.PageZoomFactor=100;

Why I gave this thing crvPayGraph.PageZoomFactor=100 is sometimes the graph will load with zoom factor 150%.

Hope this article will help you.

Edited by: micky toms on May 19, 2009 10:25 AM

[Former Member]

I have been reading all these posts with interest. We have the same issue with Windows 2008 but with a different version of Crystal Reports. We have been running eveything in Windows 2003, with CRXI 11.5.8.826, and have no issues. We have migrated to Windows 2008. CRXI 11.5.8.826 remains. We do not plan to migrate to CR 2008. All of our text reports are rendering correctly. Any report with a graph is displaying the "Fail to render page" error. I have made sure the NETWORK SERVICE account has access to the C:\windows\temp folder. I have created an APP Pool in IIS7 that is classic for this site. I have the correct handler stmts in my web.config.

I would like to know how users got this to work from 10.0 to 10.5.3700.0, or if anyone has any ideas other than upgrading to CR 2008. Many thanks.

[Former Member]

Is your problem resolved? We also stuck on the same...

~Thanks in advance

[former_member183750]

I think you're better off starting a new thread. Provide ample information. See the [Rules of Engagement|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement]

Step 2 Asking Your Question; Provide Enough Information

Looking at the blog [What do I need to do to get the fastest issue resolution?|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/12045] [original link is broken] [original link is broken] [original link is broken]; may also be of use.

Ludek

[Former Member]

I have been reading all these posts with interest. We have the same issue with Windows 2008 but with a different version of Crystal Reports. We have been running eveything in Windows 2003, with CRXI 11.5.8.826, and have no issues. We have migrated to Windows 2008. CRXI 11.5.8.826 remains. We do not plan to migrate to CR 2008. All of our text reports are rendering correctly. Any report with a graph is displaying the "Fail to render page" error. I have made sure the NETWORK SERVICE account has access to the C:\windows\temp folder. I have created an APP Pool in IIS7 that is classic for this site. I have the correct handler stmts in my web.config.

I would like to know how users got this to work from 10.0 to 10.5.3700.0, or if anyone has any ideas other than upgrading to CR 2008. Many thanks.

[Former Member]

Hi all,

I got the crystal report problem solved by installing Crystal Report 2008. Their is no other ways. You don't need to convert the crystal reports done in 10.0.3600.0 to crystal report 2008, the only thing you have to do is

After installing Crystal Report 2008 make changes in the web config like this

<compilation debug="true">

<assemblies>

<add assembly="CrystalDecisions.CrystalReports.Engine, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.ReportSource, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Shared, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Enterprise.Framework, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

</assemblies>

</compilation>

You need to change in http handler section also

<httpHandlers>

<add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

</httpHandlers>

After making these changes the next step is you have to change the web form from where the report is calling

ie,

<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"

Namespace="CrystalDecisions.Web" TagPrefix="CR" %>

Change it to

<%@ Register Assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"

Namespace="CrystalDecisions.Web" TagPrefix="CR" %>

Hope this article will help everyone struggling with Crystal Report problem.

[Former Member]

Hi all,

I resolved the issue with Crystal Reports 10 with ASP.Net 2.0 on Winows 2008 by installing CR 10.5.3700.0. And also, It is working fine with charts. It is not at all showing any error("Error: Fail to render the page".) but I am facing an issue with this setup.

Sometimes, page is showing blank blocks in the place of charts. I am suspecting that it is an issue with "CrystalImageHandler".

Can anybody please suggest me?

Thanks.

[former_member183750]

Sounds quite strange; "Sometimes, page is showing blank blocks in the place of charts". Does not look like it is related to the issue as described in this thread. Please create a new thread.

Also, in the new thread, let us know the following:

is this happening on your development computer or on a deployed server?

how did you deployed the CR runtime.

is this a custom or default web site?

32 or 64 bit?

Ludek