Hi Experts,
i am using smart table type as AnalyticalTable, and when i do so the group option is not coming in smart control setting button, Please Help,
please find the below code :
http://www.w3.org/1999/xhtml" controllerName="SmartTest.controller.View1" xmlns:table="sap.ui.table" xmlns="sap.m">
<smartTable:SmartTable id="AnalyticalTableID" useExportToExcel="true" entitySet="Results" tableType="AnalyticalTable" useVariantManagement="true" useTablePersonalisation="true" showTablePersonalisation="true" header="Line Items" showRowCount="true" persistencyKey="vehicleDetails.smartTable" enableAutoBinding="true" beforeRebindTable="onBeforeRebindTableExtension" requestAtLeastFields="EVT_DATE,VEHICLE_TYPE,OWNER_NAME,VEHICLE_NAME,VILLAGE_TRIPS">
<table:Table id="Table1">
<table:columns>
<table:Column filterProperty="EVT_DATE" leadingProperty="EVT_DATE"> <table:customData> <core:CustomData key="p13nData" value='\{"columnKey": "EVT_DATE","leadingProperty": "EVT_DATE","filterProperty": "EVT_DATE"}'/> </table:customData> <Label text="EVT_DATE"/> <table:template> <Text text="{path : 'EVT_DATE', type : 'sap.ui.model.type.Date',formatOptions: { style : 'medium'}}"/> </table:template> </table:Column> <table:Column sortProperty="VEHICLE_NAME" filterProperty="VEHICLE_NAME" leadingProperty="VEHICLE_NAME"> <table:customData> <core:CustomData key="p13nData" value='\{"columnKey": "VEHICLE_NAME","leadingProperty": "VEHICLE_NAME","sortProperty": "VEHICLE_NAME","filterProperty": "VEHICLE_NAME"}'/> </table:customData> <Label text="VEHICLE_NAME"/> <table:template> <Text text="{VEHICLE_NAME}"/> </table:template> </table:Column> <table:Column sortProperty="VEHICLE_TYPE" filterProperty="VEHICLE_TYPE" leadingProperty="VEHICLE_TYPE"> <table:customData> <core:CustomData key="p13nData" value='\{"columnKey": "VEHICLE_TYPE","leadingProperty": "VEHICLE_TYPE","sortProperty": "VEHICLE_TYPE","filterProperty": "VEHICLE_TYPE"}'/> </table:customData> <Label text="VEHICLE_TYPE"/> <table:template> <Text text="{VEHICLE_TYPE}"/> </table:template> </table:Column> <table:Column filterProperty="OWNER_NAME" leadingProperty="OWNER_NAME"> <table:customData> <core:CustomData key="p13nData" value='\{"columnKey": "OWNER_NAME","leadingProperty": "OWNER_NAME","filterProperty": "OWNER_NAME"}'/> </table:customData> <Label text="OWNER_NAME"/> <table:template> <Text text="{OWNER_NAME}"/> </table:template> </table:Column>
</table:columns> </table:Table> </smartTable:SmartTable> </core:View>
Please Help.