Page 1 of 1

Empty columns in Excel

Posted: Mon Sep 07, 2009 7:48 am
by Marinus
When I export my report to Excel (only data) I get some empty columns between the filled columns.
I thought there was a way to deal with this problem. But I don't remember it! :emb:
How can I get rid of these emty columns in Excel?

Empty columns in Excel

Posted: Mon Sep 07, 2009 6:03 pm
by Brendan
You need to make sure there are no gaps in your columns either in the header or databand. If there's spaces between the text components then those spaces will appear as empty columns in the excel output.
Using the Dock property can sometimes help to avoid this.