$('#grdData').jqGrid({
//url: 'ForeignSharesHolding.aspx?method=GetGridData',
datatype: 'json',
colNames: ['Exchange', 'Market', 'Security Name', 'Free Qty', 'Provision Qty', 'CCY', 'LDP', 'Market Value
(Free Bal)', 'Foreign Fee
Issue Date', 'Amount (SGD)', '', ''],
colModel: [
{ name: 'exchange', index: 'exchange', width: 100, align: 'center' },
{ name: 'market', index: 'market', width: 100, align: 'center' },
{ name: 'secname', index: 'secname', width: 200 },
{ name: 'freeqty', index: 'freeqty', width: 100, align: 'right' },
{ name: 'provqty', index: 'provqty', width: 100, align: 'right' },
{ name: 'ccy', index: 'ccy', width: 100, align: 'center' },
{ name: 'ldp', index: 'ldp', width: 100, align: 'right' },
{ name: 'marketval', index: 'marketval', width: 100, align: 'right' },
{ name: 'foreigndate', index: 'foreigndate', width: 100, align: 'center' },
{ name: 'amount', index: 'amount', width: 100, align: 'right' },
{ name: 'remino', index: 'remino' },
{ name: 'clino', index: 'clino' }
],
rowNum: 5,
pager: '#pgrGrid',
sortname: 'exchange',
viewrecords: true,
sortorder: 'asc',
grouping: true,
groupingView: {
groupField: ['remino', 'clino'],
groupColumnShow: [false, false],
groupText: ['{0}', '{0}'],
groupCollapse: false,
groupOrder: ['asc', 'asc'],
groupDataSorted: true
}
});
$('#grdData').jqGrid('navGrid', '#pgrGrid', { add: false, edit: false, del: false, search: false, refresh: false });