I am facing couple of problems.
1. I want to sort by any field without the group by function please see the attached web page. With ASPxPivotGrid I am able to sort only the first field and rest of the fields should be grouped for sorting to work. I dont want to use the hierarchy group by functionality hence I have changed the field property as below.
<dxwpg:PivotGridField ID="field" Area="RowArea" AreaIndex="0" ExpandedInFieldsGroup="False" FieldName="Sample" Name="field" Options-ShowCustomTotals="False" Options-ShowGrandTotal ="False" Options-ShowTotals="False" SortBySummaryInfo-SummaryType="Max" SummaryType="Max"
TotalsVisibility="None" Options-AllowExpand="False">
</dxwpg:PivotGridField>
<dxwpg:PivotGridField ID="field1" Area="RowArea" AreaIndex="1" ExpandedInFieldsGroup
="False"
FieldName="Date" Name="field1" Options-ShowCustomTotals="False" Options-ShowGrandTotal
="False"
Options-ShowTotals="False" SortBySummaryInfo-SummaryType="Max" SummaryType
="Max"
TotalsVisibility="None" Options-AllowExpand="False" CellFormat-FormatString="d" CellFormat-FormatType="DateTime" ValueFormat-FormatString="d" ValueFormat-FormatType
="DateTime">
</dxwpg:PivotGridField
>
<dxwpg:PivotGridField ID="field2" Area="RowArea" AreaIndex="2" ExpandedInFieldsGroup
="False"
FieldName="Sample Type" Name="field2" Options-ShowCustomTotals="False" Options-ShowGrandTotal
="False"
Options-ShowTotals="False" SortBySummaryInfo-SummaryType="Max" SummaryType
="Max"
TotalsVisibility="None" Options-AllowExpand
="False">
</dxwpg:PivotGridField
>
but now I dont have the group by and also I want to sort all the fields but I am not able to sort all the fields in the "row Area" , Please advice.
Secondly, I would like to allign all my columns data with respect to their header. I found similar post here
http://community.devexpress.com/forums/t/68837.aspx
and I would greatly appreciate if you could reply asap.