Crystal XI page headers truncate in excel

[lroyson]

I was using Crystal 7 and now using Crystal XI. When I export the new Crystal XI report to excel format (using a VB 6 front end to do the export) the page headers come out truncated. This same template worked in Crystal 7 on export. Any ideas?

 

[synapsevampire]

The export DLLs are always full of little problems like this, and everything changed dramatically in CR 9.

Truncated doesn't describe the problem well enough, does this mean the top, bottom, left or right?

This may also be caused by using a different printer, but obviously the solution is to expand the page header appropriately if the printer is the same.

You might also make sure that a hotfix for this doesn't exist, I'm not on CRXI at this contract or I'd test it myself..

-k

 

[lroyson]

When I view the exported data from the report in excel the right of each page header is truncated. All of the headers are 3 bytes wide except for one which I expanded out to the complete length of the field in the template. Each of the headers that appear truncated in the excel file are smaller widths in the template than the actual header text length and they are the ones that are tuncated in the exported file.

example of design view page header:
[Office] [Cla] [Po]

excel output is as follows:
Office Cla Pol

Should look like:
Office Claim Policy

 

[synapsevampire]

I see, again, this also occurs when some printers are chosen and have differnet margins availble.

If all other things are the same, then I suspect that you'll have to redo the report. Does it truncate in PDF?

Is the cutoff simply that you need to expand the column in Excel?

If it's not that you just need to make the column wider in Excel, try selection the Can Grow in Crystal, or obviously you can make the column wider.

-k

 

[lroyson]

Can you tell me more about what you mean by printer selection and how that affects excel output?

PDF truncates just like excel format.

When you expand the cell in the excel output the value is still truncated.

When I use Can Grow it does display my entire header but it puts several blank lines below the header and creates an unsightly gap between the header row and the detail data.

I have made my column width in excel much larger but I still get truncation of the headers.

 

[synapsevampire]

It sounds like the field is overlapping the print margin.

Almost every Windows program is printer dependent for display and printing, and can shift when printers change, so allowing for some shifting is essential to part of your design.

Say I have a printer which allows for 1/8 inch margins, then I send my report to someone with an old laser printer which can only support a 1/2 inch margin, if you designed out to the 1/8 mark, you're going to truncate output.

Exporting is usually more generous with this, but apparently not here.

I'm not 100% sure this is your issue, but it's a common one.

-k

 

[madelca100]

lroyson,

Can you export the report manually using File/Export?
(I use the 'Data Only' option when I export to Excel.)

Try different setting for "maintain column alignment" and "maintain relative object position". I don't know what the VB 6 code would be for these but at least you'll be on the right track.

mike