Export Crystal Report 2008 to csv has extra blank lines

When I export a Crystal Report 2008 to csv I randomly get extra blank lines.  How can I eliminate this from happening?
LVL 1
cookedwbAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Do you have a subreport?

Do you have blank lines in the report?

mlmcc
JHolycloudCommented:
If you say "Randomly", is it possible that your dataset has blank/NULL value ? So CR will show blank lines regarding this NULL value on your dataset records.
cookedwbAuthor Commented:
Yes to the subreport, but its not always showing blank lines after or before a row that had the subreport values displayed. The blank lines only appear when the report is exported as a csv.   I've set the subreport to suppress if blank.  No blank lines in the report.  I originally created the report with CR10 and when exporting to CSV it would put the headers on each row. So I saved it in CR2008.
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

HlanaiCommented:
From Crystal XI u will have issue with export to excel and csv. On the opt of the report design, where you have the number line, you need to click and put he column markers, which determine where each colum will start and end, fit your fields in between each column marker and your export will be fine.

as for your rows, you have to make sure that the fields have the same height and they are top and bottom aligned. So, fields in the same column must be left and right aligned and fields in the same row must me top and bottom aligned.

Let me know if you have a problem doing this.
mlmccCommented:
Are any of the fields more than 1 row high when they grow?

Are any lines longer than others?

mlmcc
cookedwbAuthor Commented:
I've set all the detail fields to the same size and aligned them to top.  Closed the detail section to fit, and removed my subreports.  The CSV is pipe separated.  The blank lines show the empty cells with pipes between them but they are random.  When I run the report in crystal I don't have any extra spaces between the patient information.  I'm still stumped.  I continue to play with the formatting to see what occurs.  Any more suggestions is greatly appreciated.
mlmccCommented:
Do you have any conditional suppression on the detail section?

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cookedwbAuthor Commented:
That appears to be the problem.  Is there a way or setting I need to set to keep the conditional suppression and still export without the spaces?  I'm running my report against a kb-sql database. The field i have the conditional suppression against is not an primary key within that table and the report takes a very long time to run if I add that statement within the record selection.
cookedwbAuthor Commented:
Thank you mlmcc for helping resolve this problem.  I was able to readjust my selection statement against the kb-sql database and the report run within a normal amount of time and pulls the data as expected.  The conditional suppression was removed and the file exported in a csv format with no extra lines.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.