Every single list report I export from crystal reports ends up with these two formatting options turned on for the entire excel sheet.
Also no matter how close I place my columns in Crystal I end up with spaces in between my columns in excel.
I aline all my headers and fields, I have no spaces between columns, I hide all sections not in use, report header, Group headers or footers.
Any ideas on how I can stop this from happening?
Does Crystal have some options I can set to stop this from happening?
PB
p_b_bradley 
(BOB member since 2006-03-15)
Formatting for clean export to Excel can be a challenge. Here’s what I do:
-
Column headers and column data MUST be the exact same width and MUST be aligned.
-
Column headers or data that are multiple lines high can cause merged cells between rows. I avoid them when possible.
-
All of the column headers must be the exact same height. The same holds true for the data in the various sections of your report - all objects within a section must be the same height.
-
Set guides on the ruler at the top so that it’s easy to snap objects to a specific point. I start with a guide on the left then place the first object and align it to the guide. I place the next guide at the end (right side) of the first object, so that the object is connected to both guides - left and right. I then place the next object so that it is connected to the right-hand side of the first object - it should snap to the guide. I then place a new guide on the right of the second object, and so on until I have all of my columns set up.
-
If you have header information at the top of your report make sure it lines up with the guides you have set. It may cover multiple guides, for example, start at the first guide on the left and extend to the third one on the right. The point is that it must line up left and right with data that’s below it.
I’ve had very good success with these types of rules. Beyond doing things like this, there is no way to control the export.
I don’t have the link available right now, but if you go to the SAP Crystal Reports and Dashboard Design Facebook page and click on “Notes”, you’ll find a more in-depth note about how to do this that I wrote a couple of years ago.
-Dell
hilfy 
(BOB member since 2007-04-16)