I have to create a crystal report which will be taken in excel format. Now requirement is there are few header cells which should be merged in Excel. I am not sure whether we can achieve this or not.
Ex: Attaching the sample Excel output.
If you look at the above headers, Country cell should be merged across Two cells and Customer should be merged across Firstname and Lastname cells.
Hope I explained clearly, how can we achieve this in excel? any suggestions would be appreciated. Sample.xls (13.0 KB)
The trick when formatting for a “clean” Excel export is to have your column headings be the same width as the data below them and to align the left sides. Otherwise you might end up with merged cells/columns. When you WANT to merge cells, you expand the width of the header to be exactly as wide as the combination of columns you want to merge it over. To use your “Customer” example, place a text box above the firstname column in your data and align the left sides of the text box and the field. Extend the right side of it so that it EXACTLY matches the right side of the lastname field. This should give you a merged cell over the top of the two columns.
Thanks for your suggestion. Actually it will not work. No matter how big/small the filed width is in crystal, it will be placed in a single cell when you export into crystal. Any other ideas?
(BOB member since 2007-07-04)
(BOB member since 2007-04-16)