Joined: 30 Mar 2009
Location: United States
Online Status: Offline
Posts: 2
Topic: Blank lines in Excel output Posted: 30 Mar 2009 at 12:16pm
Hi. I am getting a blank row in my excel output at the bottom of each of my sections (Report Header, Page Header, Details). Is there anyway to suppress these?
I am using Crystal 11.5, with export option "Microsoft Excel 97-2000 (XLS)".
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 31 Mar 2009 at 4:22pm
Have you tried using the "Microsoft Excel 97-200 (Data Only)" export? The one that you're using tries to format the output to be "pretty" so there are extra rows, merged columns, etc. The Data Only export does just that - no extra formatting, just the data. It seems to be a much cleaner export if you need to manipulate the data.
Joined: 30 Mar 2009
Location: United States
Online Status: Offline
Posts: 2
Posted: 03 Apr 2009 at 5:21pm
hilfy:- I do need some fields displayed at the top so can't use the "Data Only" option unfortunately. The problem is that the receiving client website requires fields to begin at certain rows. With Crystal adding extra blank rows, we are having to delete these rows before submitting. It would be nice if we didn't have to.
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
IP Logged
