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
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
RE: Export to excel without excel creating blank rows
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,
Just traded in my OLD subtlety...
for a NUance!
RE: Export to excel without excel creating blank rows
RE: Export to excel without excel creating blank rows
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Export to excel without excel creating blank rows
RE: Export to excel without excel creating blank rows
RE: Export to excel without excel creating blank rows
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
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
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
view, export, burst, email, and schedule Crystal Reports.
www.MilletSoftware.com
RE: Export to excel without excel creating blank rows