Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extra blank line at page break when exported to Excel

Status
Not open for further replies.

RenaG

Programmer
May 3, 2011
132
US
Hi,

I am working in Crystal 2010. I have a main report whose only purpose is to get the date parameters. Then in the Report Footer, I have a subreport that uses a Command to report off of. I have the report tightly formatted so that when I export to Excel it looks perfect (no extra columns or rows). Except at the page break - I am getting an extra row at the page break. Is there some way I can get rid of this? At this point, I have made the report ridiculously long (100 inches) which gets rid of most of the blank lines but not all of them. But I don't really like this work around and hope there is another solution.

TIA!
~rlg
 
Hi,

Why in the world would you inflict such a thing as a formatted report by exporting to Excel, where your report has rendered virtually useless for the many features of Excel?

A data table would be much MUCH more appropriate for Excel than a pretty report that you might send as a pdf.

Just my not so humble opinion!

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Thank you, Skip, for your "not so humble opinion". When I said it was a formatted report, what I meant is that I have all the fields snug up against each other and the lines "fit to section" so that I don't have extra spaces showing up in the exported Excel file. It is not a "pretty" Crystal report that is being exported but rather a functional spread sheet that the user can manipulate at will.

If you have a constructive solution, I would love to hear it. [bigears]

~rlg
 
Can you export your query data, rather than the report data? I know that that can be done in Business Objects Web intelligence. I can export a .csv file and IMPORT (not OPEN) into Excel and parse the data on the comma, controlling the conversion of string to number or date where appropriate.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
I am not sure this option will work for our users. However, when I tried to do it myself, I opened Excel, went to the Data tab and selected From Text. Found the csv file and imported it. Nothing happened. It never opened the file. I am using Office 2013 on Windows 7.
 
Nothing happened. It never opened the file.
so you NEVER got ANY data into your sheet using the Import External Data > Text File method?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
During the Import process, did you select Delimited and the Comma delimiter?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Ok, I see what happened. Nothing exported to CSV (file size is 0).

I just tried it again and still nothing is there. When I selected CSV in the export from Crystal, I took all the defaults. Why wouldn't it export anything?

It exports to Excel ok (except for those extra blank lines - which is the subject of this tread [smile]).

~rlg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top