We help IT Professionals succeed at work.

Crystal Reports .Net Viewer Failed to Render the Page

mattolan
mattolan asked
on
3,917 Views
Last Modified: 2008-01-09
I have a crystal report that is being displayed in a web app using the crystal report viewer. this report contains 8 sub reports. none of the sub reports will display. The viewer page turns yellow and gives the following error "Error: Fail to render the page." (Fail is Fail in the error not Failed) Yet I can print or export the report and it shows up fine, it just won't display in the viewer for some reason.  If I remove the sub reports then the report will display?
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
This article may be useful

http://support.businessobjects.com/library/kbase/articles/c2014843.asp

If that doesn't help, do the subreports have images?

mlmcc

Author

Commented:
the link wasn't my issue, I tried that but no luck,

Yes my subreport does have images
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
this does appear to be the problem; I am running vista on my machine, and I am assuming it is preventing it from writing the images. I tried the reports on a machine running XP and they worked just fine.

this is another mark against crystal reports in my books, and the book is filling up very quickley
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Why a mark against Crystal?  MS changed the OS.  Vista is very different from XP.

Have you installed the Crystal updates for Vista?

mlmcc

Author

Commented:
crystal does not have any updates for the oem versions of there products which is what I have (the visual studio .net version)

its crystals fault for attempting to cache data outside of the browsers cache folders, not vista's

Crystal is also grossly ineffiecent. the more I work with it the nastier it gets.
for example crystal posts back and re-runs the entire query for every sub report, it also does this for every page in a report when you print it. so if I have a 40 page report. and I print it, crystal runs the entire query for every page. and the queries themselves are nasty. crystal basiclly does a select all, then narrows the data using my parameters once it has loaded it into the report. I have one report that returns 500MB of data using the query that crystal builds! if this report is 30 pages and the user wants to print it. thats 15GB of data being transfered between the web server and the database server

also has a nice bug where it doesn't close a report in server memory unless you catch the page unload event and specifically tell it to close the report
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Crystal has updates for the .net versions.  There isn't one yet for VS 2005
http://support.businessobjects.com/downloads/service_packs/crystal_reports_en.asp

How are you filtering the data?  If you are using Crystal functions then all the data must be returned to Crystal.

mlmcc

Author

Commented:
I am using VS 2005, this is an old report from version 8.5 and at the momemt there is no data filtering it all loads into crystal, which is what I said, crystal builds a select but ignores your parameters until after it loads the data, this is inefficient, and it will also repeat this query for every page in the report if you print the document
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
What are the parameters for?  Are they used in the SELECT EXPERT?

mlmcc

Author

Commented:
they are a date range and they are used in the SELECT EXPERT
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Depending on how you use it in the select expert (that is the filtering), Crystal may not be able to pass the filter to your database.

What is in the Select expert.

mlmcc

Author

Commented:
the Select Expert contains a date range  (From Date, To Date)
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
What is the exact statement, something like

{YourFIeld}  >= {?FromDate} and {YourField} <= {?EndDate}

mlmcc

Author

Commented:
essentially yes
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
If it is just like that then it should be passed to the database for filtering.  If it is different then it may have to be done by crystal.

mlmcc

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.