Mike,

Finally we moved to IG 2011 v.2 last week. After the upgradation we found some problems in the excel export.

I have the grid with multi band (2 bands). I set the headerplacement position of the grid as "default". I gave provision to enable summary, filter and as well as groups. While exporting it to excel i faced following issues :

1) If i set summary to column and on export, header is coming before the summary rows (Refer : Pic 5 in attachment)

2) If i enable and applied filter, only the filtered rows are showing in the grid. But on export many rows header are showing (ex. assume that if i have 5 rows and while applying filter, the grid is showing only one row. On export, the excel having 5 header rows and 1 data row)( refer PIC 04 in attachment)

3) If i changed the Headerplacement of the 1st band as "Fixedontop" and 2nd band as "default", on export it is showing headers of 2 bands on the top (Refer : PIC 07 in the attachment)

I herewith attached a sample project for your reference:

Steps to reproduce the issues:

Problem 1:

Step 1: Run the project

Step 2 : Click "Apply summary" on the top

Step 3: Select some value in Summary dialog (Ex : select Sum, Average)

Step 4: Click "Excel export"

Step 5 : Check the summary rows having headers

Problem 2 :

Step 1: Click "Apply Filter" after executing the sample project

Step 2: Give the filter as "2" in the column "Text column1". It will show only 1 row.

Step 3:  Now click "Excel export"

Step 4: Check the excel showing 5 header rows

Problem 3:

Step 1 : Open the project and go to "Form1_Load"

Step 2 : Uncomment the below mentioned line at the end of event

"grdReport.DisplayLayout.Bands(0).Override.HeaderPlacement = HeaderPlacement.FixedOnTop"

Step 3 : Run the project

Step 4 : Click "Excel export"

Step 5: Check we are getting header of 2 band on the top.

Is there any properties to override this problems.

Guide us to solve the issue.