Print Page | Close Window

export to excel

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1664
Printed Date: 04 May 2024 at 9:25am


Topic: export to excel
Posted By: rajeshkottakota
Subject: export to excel
Date Posted: 11 Nov 2007 at 9:15pm

Hi,

I developed a simple report, while exporting into excel some labels are missing...

Exporting into pdf working fine...

Only the problem with excel only... Can u help me... What's the problem exactly?

Thanks & Regards
Rajesh


Replies:
Posted By: fusion
Date Posted: 13 Nov 2007 at 1:10pm
Rajesh,
I had similar issue while exporting to Excel. I would get blank for zero values. But when I clicked on the field, I would see that it is zero. I don't know how I can overcome this problem.
In you case, I think you have to check filed length in design view so that one does not overlap others. What you see is what you get. so you have to format you report in Excel friendly way such as not leaving space between fields. Hope this helps.

Posted By: BrianBischof
Date Posted: 13 Nov 2007 at 3:25pm
It's important in Excel to make a report similar to a grid to make sure that all the fields gets formatted correctly. If things aren't lined up well, then it can be tough for CR to export to Excel and make sure overlapping fields get positioned correctly.

I give a list of tips and suggestions for exporting to Excel on pages 551-555 in my book.


-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: rajeshkottakota
Date Posted: 13 Nov 2007 at 6:19pm
Thanks a lot, it's working fine.


Print Page | Close Window