Hello Derrick,

Since I cannot be completely sure how your data is organized, I am not able to conclude what can cause your behavior, so could you please send an isolated sample project, where the issue is reproduced, so I can investigate it further for you.

Looking forward for your reply.

Here is the CS code using the XamDataGrid

Microsoft.Win32.SaveFileDialog saveDlg = new Microsoft.Win32.SaveFileDialog();
saveDlg.Filter = "XLS documents|*.xls";
if (!saveDlg.ShowDialog().GetValueOrDefault())
return;

DataPresenterExcelExporter exporter = new DataPresenterExcelExporter();

exporter.Export(this.indgPEVSummary, saveDlg.FileName, WorkbookFormat.Excel2007);
Process.Start(saveDlg.FileName);

I still get the error here is my xaml code and I used your .cs code to display Excel

<igDP:XamDataGrid Grid.Row="1" FieldLayoutInitialized="indgPEVSummary_FieldLayoutInitialized"
Name="indgPEVSummary" AllowDrop="True" GroupByAreaLocation="None" Margin="10,10,10,0" AutoFit="True"
Style="{DynamicResource DMIGridWiewStyle}" HorizontalContentAlignment="Center" Sorting="indgPEVSummary_Sorting"
RecordActivated="indgPEVSummary_RecordActivated">
<igDP:XamDataGrid.FieldLayoutSettings>
<igDP:FieldLayoutSettings AutoGenerateFields="True" DataRecordSizingMode="SizedToContentAndIndividuallySizable"
RecordSelectorLocation="None" DataRecordCellAreaStyle="{StaticResource WhiteGrid}" AllowFieldMoving="No">
</igDP:FieldLayoutSettings>
</igDP:XamDataGrid.FieldLayoutSettings>
<igDP:XamDataGrid.FieldSettings>
<igDP:FieldSettings AllowEdit="false" AllowResize="True" LabelClickAction="Default"></igDP:FieldSettings>
</igDP:XamDataGrid.FieldSettings>
<igDP:XamDataGrid.FieldLayouts>
<igDP:FieldLayout Key="Parent">
<igDP:FieldLayout.Fields>
<igDP:Field Name="FieldID" Visibility="Collapsed"/>
<igDP:Field Name="FieldName" Label="{DynamicResource Field}"/>
<igDP:Field Name="ComparisonFieldID" Visibility="Collapsed"/>
<igDP:Field Name="ComparisonFieldName" Label="{DynamicResource ComparsionField}"/>
<igDP:Field Name="UOMFieldID" Visibility="Collapsed"/>
<igDP:Field Name="UOMFieldName" Label="{DynamicResource UOMField}"/>
<igDP:Field Name="FieldTotal" Label="{DynamicResource FieldTotal}"/>
<igDP:Field Name="ComparisonFieldTotal" Label="{DynamicResource ComparisonFieldTotal}"/>
</igDP:FieldLayout.Fields>
</igDP:FieldLayout>
<igDP:FieldLayout Key="Node">
<igDP:FieldLayout.Fields>
<igDP:Field Name="FieldID" Visibility="Collapsed"/>
<igDP:Field Name="FieldName" Visibility="Collapsed"/>
<igDP:Field Name="ComparisonFieldID" Visibility="Collapsed"/>
<igDP:Field Name="ComparisonFieldName" Visibility="Collapsed"/>
<igDP:Field Name="EndItemID" Visibility="Collapsed"/>
<igDP:Field Name="EndItemName" Label="{DynamicResource Item}"/>
<igDP:Field Name="BusinessKey" Label="{DynamicResource SoldToShip}">
<igDP:Field.Settings>
<igDP:FieldSettings LabelMinWidth="200" CellMinWidth="200"/>
</igDP:Field.Settings>
</igDP:Field>
<igDP:Field Name="UOMFieldID" Visibility="Collapsed"/>
<igDP:Field Name="UOMFieldName" Visibility="Collapsed"/>
<igDP:Field Name="FieldQuantity" Label="{DynamicResource FieldQuantity}"/>
<igDP:Field Name="ComparisonQuantity" Label="{DynamicResource ComparisonFieldQuantity}"/>
<igDP:Field Name="Error" Label="{DynamicResource Error}" />
<igDP:Field Name="ErrorUnits" Label="{DynamicResource ErrorUnits}"/>
</igDP:FieldLayout.Fields>
</igDP:FieldLayout>
</igDP:XamDataGrid.FieldLayouts>
</igDP:XamDataGrid>

Hello Derrick,

I have created a sample project for you where i used version 10.3 with the latest service release (2337) and everything seems to work ok on my side. If yo udoesn't have the latest service release you can download it by logging to our web site and going to Account \Keys & Downloads.

Hope this helps you.