Hi!

I think the answer to this is no, and it was asked before here - http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7125 - with no answers, which kind of confirms my theory..

I have a report which pulls customer data with products they've purchased, and multiple products mean multiple lines of data. I need to convert this into a single line for each supporter with the products in columns of their own, which I've done with a crosstab query. However this report is to be used for mail merging, so it's being exported to Excel. The crosstab doesn't have column headers so I've made my own with text boxes, but whenever the data is exported to excel these are on a line above the crosstab data, like this.

Customer             Address
                                               Product1          Product2
A                         XXXX                   X                      X

Is there any way to either make crosstab headers that would export correctly to Excel, in the same line as the crosstab column headers, or is there another way to convert my multiple lines of data for supporters with multiple products into a single line with the product field data pivotted so it's in the report rows?

Thanks in advance! :)