Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Excel output looks bad Post Reply Post New Topic
Author Message
eeps24
Newbie
Newbie


Joined: 23 Jul 2015
Online Status: Offline
Posts: 3
Quote eeps24 Replybullet Topic: Excel output looks bad
    Posted: 26 Aug 2015 at 9:51am
I have a report in crystal which looks visually pleasing (first time using it Smile) but when I export it to excel it looks really bad also all the lines are missing around the cells. 

What can I do in my report so I export the color of my header, bold print, lines in the report?  I know there is an option to export with just data but that looks really really plain.

please help
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 27 Aug 2015 at 5:13am
Hi,

Crystal is VERY picky about format when exporting to Excel. In order to get a "clean" export check the below KB article and links

http://search.sap.com/notes?id=0001364230&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64653D3939382669765F7361706E6F7465735F6E756D6265723D30303031333634323330

http://scn.sap.com/community/crystal-reports/blog/2013/03/27/tips-to-export-crystal-report-rpt-to-excel

http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=14100

--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 27 Aug 2015 at 7:02am
Also, lines will not export to Excel. All they'll do is cause empty columns and rows. However, there is a way to get them by using object borders.

Within a "row", you'll set the top, bottom, and right borders for each objects. For the object that is furthest to the left you'll also set the left border. I usually use ruler guides at the top to make sure that the right edge of one object is the left edge of the object to its right so that you get a continuous horizontal line across.

If you have multiple sections that show, set the top border for objects in the top-most section only; for everything below that leave out the top border. Make sure that the Y value for the position of the objects in a section is 0 so that they're at the very top of the section. Then make sure that the bottom of the section is up against the bottom of the objects in that section. This will make the vertical lines continuous.

-Dell
IP IP Logged
FatJosh
Newbie
Newbie


Joined: 04 Sep 2015
Online Status: Offline
Posts: 1
Quote FatJosh Replybullet Posted: 14 Sep 2015 at 12:41pm
I have spent a lot of time trying to find ways to make my reports export to excel in the exact way I need them. Rows are pretty easy to line up. To line up columns you want to make sure you have the same number of objects on each row. You can add a blank text object and it will export as a blank field in excel. I use this a lot to line reports up for excel.

For example:
Row1 Name - [blank text object] - Address - [blank text object]
Row2 Josh - Fat - #1 - Happy St       

You will export with Name in cell A1, Address in C1, Josh in A2, Fat in B2, #1 in C2, and Happy St in D2
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.016 seconds.