Some issue with Title when generating a Excel file from a crystal report.

Two issues I spent some time resolving was:

1. When an excel file was generated from crystal reports some times the assosciated title for the column does not appear correctly.
   
2. Every time I generated an Excel file from crystal reports. The titles in the excel file were never in the same order as I had created them in crystal report.
   

Fig 1 : This will not work

Resolution to the issues above:

1. For all the columns that you require to appear in excel they must touch the details section.
2. For the Titles to be in the same order as in crystal,all fields must have the same height. For some reason the order seems to be based on height.

Below is the corrected crystal report Image.

Fig 2. This will work