• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3123
  • Last Modified:

Crystal Reports .Net Viewer Failed to Render the Page

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?
0
mattolan
Asked:
mattolan
  • 8
  • 7
1 Solution
 
mlmccCommented:
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
0
 
mattolanAuthor Commented:
the link wasn't my issue, I tried that but no luck,

Yes my subreport does have images
0
 
mlmccCommented:
Check this link about permissons to the image files.
http://support.businessobjects.com/library/kbase/articles/c2010532.asp

mlmcc
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
mattolanAuthor 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
0
 
mlmccCommented:
Why a mark against Crystal?  MS changed the OS.  Vista is very different from XP.

Have you installed the Crystal updates for Vista?

mlmcc
0
 
mattolanAuthor 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
0
 
mlmccCommented:
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
0
 
mattolanAuthor 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
0
 
mlmccCommented:
What are the parameters for?  Are they used in the SELECT EXPERT?

mlmcc
0
 
mattolanAuthor Commented:
they are a date range and they are used in the SELECT EXPERT
0
 
mlmccCommented:
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
0
 
mattolanAuthor Commented:
the Select Expert contains a date range  (From Date, To Date)
0
 
mlmccCommented:
What is the exact statement, something like

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

mlmcc
0
 
mattolanAuthor Commented:
essentially yes
0
 
mlmccCommented:
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
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now