Extra blank line at page break when exported to Excel

[RenaG]

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

 

[SkipVought]

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]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RenaG]

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.

~rlg

 

[SkipVought]

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]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RenaG]

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.

 

[SkipVought]

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]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RenaG]

That is correct.

~rlg

 

[SkipVought]

During the Import process, did you select Delimited and the Comma delimiter?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RenaG]

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 ).

~rlg