INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Export to excel without excel creating blank rows

Export to excel without excel creating blank rows

(OP)
Hello,
After much tedious work, I finally have the report exporting to excel without merging the column cells, but I cant get it to not create blank rows between the populated rows. I have the section in the CR report as tight as I can get it to the fields, any ideas on how to solve this one?

thanks

-CJ

SQL2014// CR Pro 11.5.0.313// Windows 7 Enterprise

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

RE: Export to excel without excel creating blank rows

Two things to check. All the fields are the size (exactly) and they are all lined up (select all and align top). The right click on section and fit to section.

RE: Export to excel without excel creating blank rows

HI,

I hate, absolutely hate, (did I mention hate?) getting reports in Excel. They are nearly ALL, just about every one of 'em, virtually USELESS!!!

Did I mention that I universally hate getting reports in Excel?

Just generate a .csv file that I can IMPORT into a workbook.

If you want a pretty report, just generate a PDF. In Excel, I don't want pretty. I need useable data in a proper table.

Did I mention that I detest reports in Excel?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Export to excel without excel creating blank rows

Not sure but I think Skip doesn't care for reports in Excel, or am I reading too much into his post?

RE: Export to excel without excel creating blank rows

👍

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Export to excel without excel creating blank rows

I totally disagree with Skip. I also had trouble while I first started working on exporting reports to Excel, but now I am able to export reports without any unwanted columns or rows.

RE: Export to excel without excel creating blank rows

Unfortunately the need to export to Excel is usually misguided. I have seen that the users want to change the data, or add more data (that probably was available for the report). If they just need the raw data or an import to another database, then I push for .csv.

RE: Export to excel without excel creating blank rows

I agree Kray. The approach I started taking was to either create a small SSIS package and email the results of a query in an Excel file, or link a spreadsheet to the SQL server back end and let the user refresh and do whatever they want in the spreadsheet. I've always felt it kind of defeated the purpose of creating a Crystal Report if all the user was going to do was analyze/tweak/manipulate the resulting data anyway. And to Skip's point, I agree, if you want a REPORT, not a data source, then definitely use the powerful formatting features in Crystal.

And that, plus a buck fifty, gets you a cup of coffee in my neck of the woods ;)

RE: Export to excel without excel creating blank rows

(OP)
Thank you all for your posts,
the need for this is to give them the data to populate an excel workbook, from there they already have their charts, graphs and so on. I'm replacing a system and I need to make sure they can still get their data, its a band aid at this point until I can take the time to build a full report to replace what they have today. thanks. I am going to explore the csv export, BTW did you hear Skip doesn't like getting reports in excel? its a rumor going around :)

-CJ

SQL2014// CR Pro 11.5.0.313// Windows 7 Enterprise

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

RE: Export to excel without excel creating blank rows

The first thing I would look for is space in the section ABOVE the fields or subreports.

This article might also help:
http://kenhamady.com/cru/archives/2712

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
http://www.kenhamady.com/

RE: Export to excel without excel creating blank rows

One of the 3rd-party tools listed on Ken Hamady's web site automatically removes blank rows from the Excel (Data Only) exports.

view, export, burst, email, and schedule Crystal Reports.
www.MilletSoftware.com

RE: Export to excel without excel creating blank rows

Easiest way to avoid extra lines: Select "Excel data only" as your export type

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close