Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 366
	Members: 1
	Total: 367

	Online Now:
	BLott

New Topics

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
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 Send Private Message

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 Send Private Message

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: 3351

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 Send Private Message

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 .