Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Exporting to Excel without extra columns Post Reply Post New Topic
Author Message
AmyTheJoy
Newbie
Newbie
Avatar

Joined: 03 Sep 2013
Online Status: Offline
Posts: 6
Quote AmyTheJoy Replybullet Topic: Exporting to Excel without extra columns
     Posted: 03 Sep 2013 at 11:51am
Hello Amazing People,

I have a client that needs his reports in Excel, but when I export to Excel from CR, a wide variety of narrow rows and columns show up in between those holding the pertinent data. The client needs his results in SPECIFIC CELLS, but I do not know how I can accomplish that translating my Crystal Reports report into Excel. Ideas?
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 04 Sep 2013 at 2:55am
Hi Amy,
 
What is the version of Crystal Reports?
What is the export type are you using to export the report from Crystal Report designer?
Is it MS Excel(97-2003) or MS Excel(97-2003)Data-Only format?
Try with different format..
Try to export the report to PDF format and check whether are you getting same format as in designer..
 
--Praveen G
 
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
AmyTheJoy
Newbie
Newbie
Avatar

Joined: 03 Sep 2013
Online Status: Offline
Posts: 6
Quote AmyTheJoy Replybullet Posted: 04 Sep 2013 at 4:45am
It's Crystal 2008. I am using the MS Excel 97-2000 format. The Data Only... defeats the purpose of using Crystal Reports to format it. The PDF format comes out great.

Thanks bunches for any assistance you can give.
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 04 Sep 2013 at 5:27am
Hi Amy,
 
Adjust the fields sizes in Design tab.
Make sure all the fields are in same height(Y axis value).
Make sure there is no space between fields(column wise).
If you have any empty space in the section then adjust the size(by Right click on the section and select Fit Section)
If possible, Can you post the screen shot of your excel and Design tab?
 
--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.