CR 11 drops formatting in 25+ page exported HTML

[ChristianWhite]

Crystal 11; XP Professional sp2; SQL Server 2000


My HTML 4.0 export, having grown past about 25 pages, drops formatting around the 25-page mark: Bolds and underlines disappear; the font size stays fixed; the pages break without regard to design of where they should fall, splitting charts between pages; and the right margin of the page devours the right edge of my charts.

Here is an article I've seen. This issue was present in Crystal 9, and apparently has not been fixed.

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

Crystal recommends separating the HTML file into multiple files in the article--which I have tried, but the result is not satisfactory: a report the users can only view one page at a time; to see page 25 of 50, they'll have to view page 1, then 2, then 3...not desirable for users who would rather glide through all pages of a 25+ page report at the touch of a scroll bar.

The PDF, RTF, and XLS versions of the file are accurate copies of the original. But in HTML--one of two formats the client has specified--neither single- nor multiple-file yields an acceptable product. I have had possible link problems reported with multiple, which may rule multiple out--so, barring a better solution, I may be stuck with a single-file HTML that looks butchered after the first 25 pages.

Any suggestions?





My main-report structure:

RH has a .jpg
PH--just spacing; conditional (doesn't show on page 1)
Group 1 Header--prints publisher name, publication name,
and 15 - 25 subreports for each publication
Group 1 Footer--visual page break ending group, simple graphics, prints publication name
RF--prints publisher name; has summary reports


Main report requests parms:
Publisher
Format (for a formula that causes a graphic to appear when we create PDF files)
Month to view (one subreport uses it)
Year to view (one subreport uses it)

Main report gets a resultset in the format
Publication code (varchar 65)
Publication (varchar128)

 

[ChristianWhite]

Let me revise the layout I described--
the 15-25 subreports are in details a and details b, not in the group header.

 

[synapsevampire]

15-25 subreports in a details section??? Very scarey, the performance must be horrendous...

Try creating a better datasource (View, SP?) to return the data required for the subreports as subqueries within the main report, or use derived tables in SQL so that you have a single data source if possible.

I've heard numerous complaints about HTML 4, however I seem to get decent results, providing I keep things simple and keep objects away from margins, and have the same printer on the client machine as what I developed with.

No doubt it has some ugly aspects though.

-k