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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross tab --> Excel Bug?

Status
Not open for further replies.

Hubajube

Programmer
Mar 6, 2002
25
US
I have a report that uses a Cross Tab with a date column. I have customized the Group Name by using a formula to display mm/dd. It looks fine in the preview, but when I export to Excel I get gibberish, stuff like this:

Xh%
fh%
mh%
{h%
‚h%
h%

I don't see this bug reported on Crystal. Anyone else encountered this?
 
What version of Crystal are you using? In 8.5, at least, you have <Column width based on objects in area> within <Format Options>. I had nothing like your problem, but I did get improved results by using the detail line rather than thr group header, which was the default Madawc Williams
East Anglia
Great Britain
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top