Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 331
	Members: 0
	Total: 331

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

Blank rows in excel export of crystal report

3 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Jon Lunn

Basic Member

Posts: 5

4/8/2009 2:55 PM

Hi,

I've got a few crystal reports that are set to open as excel files. however it seems to populate blank rows between the lines of data. I've reduced the line space between the rows in crystal as much as possible.

has anyone got any ideas??

CR XI R2 SP4
LBI 9.0.1.8

Thanks

Jon

Matthew Nye

Veteran Member

Posts: 514

4/8/2009 3:40 PM

Jon,

I would make sure you suppress all unused headers and footers and if you arent using the details section suppress that too. If you only have it set for Allow Drill Down its still going to show it in the export.

John Henley

Posts: 3353

4/8/2009 4:55 PM

Another thing to look at is how you have the fields anchored in their respective sections. If you don't have them all attached to the same (vertical/Y-axis) anchor (i.e. they are haphazardly placed), they will get messed up in the translation to Excel.

Shane Jones

Veteran Member

Posts: 460

5/28/2009 2:24 AM

I had this and finally gave up and created a sorting macro for the users.... This is in excel and then hit a keystroke that sorts everything by the value in the first column and since the blank rows have nothing they show up at the bottom.... (I know it was a quitters solution but I had bigger issues to worry about and the solution was easy .