Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal XI export plucks charts

Status
Not open for further replies.

ChristianWhite

Programmer
Jun 14, 2004
41
US
I'm exporting a Crystal 11 report to HTML 4.0: a main report with five linked subreports.

Regardless whether I've chosen the option for pages separated or not, subreports that have a chart appear having everything except the chart. The other subreports are 100% as expected.

I'm opening the files by clicking on the file Report.html or Report1.html, depending on whether I've asked for files respectively nonseparated or separated. IE opens the file.

If I try exporting to HTML 3.2, my resulting file is a train wreck: graphics stretched, boxes misplaced--so, although my output must be HTML, I don't have 3.2 as an option.

Generally, what kind of problem could that be? DLLs? Guidance appreciated !




OS: XP Professional SP 2
Crystal XI, SQL Server 2000
 
Probably also worthy of note: I export to PDF, XLS, and HTML 3.2, and see the chart objects in each case. HTML 4.0, on the other hand, drops them.
 
I stripped down my main report until it comprised only one subreport; the subreport contained a chart object. The main report had only one record for the linked subreport to execute ! For this test with this relatively simple report, I alternately used both settings of the separate-file checkbox.

The exported HTML 4.0 file still did not display the chart object in the subreport.

Crystal has an article at


which suggests my report might be exceeding browser limitations. But I doubt a single subreport with simple chart with five bars of summary data--in a main report having a small resultset--should overrun browser capacity.
I have executed 4.0 exports twice this size, with chart objects in twice as many subreports, that came out as intended. I wonder if the fact the pies weren't linked to the main report, or contained in a group, could have been significant.

Comments welcome !
 
I don't have CR XI installed here, but in CR 9 I can export to HTML 4 and it includes a bar graph when I just tested.

Consider posting the type of graph that you're exporting, as well as the page orientation. Perhaps it's exceeding the page size and being dropped.

I tend to use PDF for exported web reports as it tends ot most closely imitate the original report, and almost everyone can open PDFs.

You might also check for updates to CR XI.

-k
 
How I would love to export to just PDF! Unfortunately, the client has also specified HTML.

You got me thinking about problems with objects not fitting or layering right, though, and I've got the charts--bar charts--appearing now, having gone into the exported HTML main file and manually edited the z-index on the reference to each chart-object file. Unfortunately, the full batch of reports will probably need several hundred edits like that. The idea was to AUTOMATE the export process, so as a long-term fix it won't do.

I've known the chart-object files have been produced and sent to the right directory all along. The question up until now had been: Why hadn't they been appearing in the main report?

That resolved with the manual z-index edits, what I'm wondering now is: If I've been directing the subreports to bring their chart objects to the front all along, why does the HTML not seem to reflect it? In the Crystal runtime, nothing overlaps the chart; but in the exported HTML, if I change the z-index, these bar charts appear. Some objects in the same subreport with a chart actually have higher z-index values in the HTML.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top