Running Crystal XI (11.0.0.2495) & exporting to Excel 2003.

 

Using dynamic SQL query to generate report fields on clients.

 

My report has two detail lines - one which will show more information than the other, depending on the detail required:

A - has 11 fields

B - the same 11 fields plus an extra 4 fields.

 

I have two page headers that match the fields in the detail line:

 

All of the fields & field headings are the same font size & I have used the guidelines to line everything up.  The last field in detail A is as wide as the extra four fields in Detail B (thus the report width is the same). 

 

I have a string parameter to suppress the page header & detail depending on user choice:

1  = High

2 =  Detail

 

I have used the following formula in my page header & detail line.

eg {?Report type}="1"

 

Now for the weird bit.

When I export to Excel, my columns misalign.

I have tried putting the headings as report header (split over a & b) but I get the same problem.

 

If I remove one of the page headers & matching detail line from the report - everything lines up.

If I remove the use of the parameter- everything lines up.

If I use export to Excel (data only) - everything lines up.

 

It really seems to the be use of the parameter.

I'm sure I've done this successfully before - but never with an SQL query generating the fields.

 

Help?