Blank lines in Excel output
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5928
Printed Date: 07 May 2024 at 12:56am
Topic: Blank lines in Excel output
Posted By: Torres
Subject: Blank lines in Excel output
Date 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)".
Thanks,
Torres
|
Replies:
Posted By: hilfy
Date 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.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: joshdooley
Date Posted: 03 Apr 2009 at 10:27am
|
Are you M Torres, formerly with Fidelity by chance?
|
Posted By: Torres
Date 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.
joshdooley:-
No, sorry.
|
Posted By: hilfy
Date Posted: 04 Apr 2009 at 10:14am
|
Unfortunately, there's not really any way to control how Crystal does its Excel export to prevent those extra lines. Sorry!
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|