I have one Jquery Grid ,
binded data from DB,
the issue is i need to merge cells in column one that has the same values toegter.
Below is my code
<html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server"> <title></title> <!-- The jQuery UI theme that will be used by the grid --> <link rel="stylesheet" type="text/css" media="screen" href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.10.0/themes/excite-bike/jquery-ui.css" /> <!-- The jQuery UI theme extension jqGrid needs --> <link rel="stylesheet" type="text/css" media="screen" href="themes/ui.jqgrid.css" /> <!-- jQuery runtime minified --> <script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.9.0.min.js" type="text/javascript"></script> <!-- The localization file we need, English in this case --> <script src="js/trirand/i18n/grid.locale-en.js"type="text/javascript"></script> <!-- The jqGrid client-side javascript --> <script src="js/trirand/jquery.jqGrid.min.js" type="text/javascript"></script> <style type="text/css"> .ui-jqgrid tr.jqgrow td{height:100px; font-size:large; font-weight:bold;} $("#grid").closest("div.ui-jqgrid-view") .children("div.ui-jqgrid-titlebar") .css("text-align", "center") .children("span.ui-jqgrid-title") .css("float", "none"); </style> <style type="text/css"> body { font-size: 75px; } </style> </head> <body > <form id="form1" runat="server"> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ connection string value %>" SelectCommand="select distinct M.MINOR_NM [SVC Type],'In Warranty' WTY, (select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type='W1' and Service_type in ('T1')) Total, (select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type='W1' ) '0~3 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type='W1' ) '4~7 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type='W1' ) 'Over 7 Days' from mytabe1 J join mytabe2 M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T1') Union select distinct M.MINOR_NM [SVC Type],'Out Of Warranty' WTY, (select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type in('W6','') and Service_type in ('T1')) Total, (select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type in ('W6','')) '0~3 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type in ('W6','')) '4~7 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T1') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type in ('W6','') ) 'Over 7 Days' from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T1') Union select distinct M.MINOR_NM [SVC Type],'In Warranty' WTY, (select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type='W1' and Service_type in ('T4')) Total, (select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type='W1' ) '0~3 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type='W1' ) '4~7 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type='W1' ) 'Over 7 Days' from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T4') Union select distinct M.MINOR_NM [SVC Type],'Out Of Warranty' WTY, (select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type in('W6','') and Service_type in ('T4')) Total, (select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type in ('W6','')) '0~3 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type in ('W6','')) '4~7 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T4') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type in ('W6','') ) 'Over 7 Days' from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T4') Union select distinct M.MINOR_NM [SVC Type],'In Warranty' WTY, (select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type='W1' and Service_type in ('T2')) Total, (select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type='W1' ) '0~3 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type='W1' ) '4~7 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type='W1' ) 'Over 7 Days' from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T2') Union select distinct M.MINOR_NM [SVC Type],'Out Of Warranty' WTY, (select count(*) Total from w_job_header_usg105 a where a.job_status<'60' and a.Cost_type in('W6','') and Service_type in ('T2')) Total, (select count(*) from w_job_header_usg105 A where a.job_status<'60' and a.Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),a.RECEIPT_DT,120),getdate())<=3 and Cost_type in ('W6','')) '0~3 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>3 and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())<=7 and Cost_type in ('W6','')) '4~7 Days', (select count(*) from w_job_header_usg105 where job_status<'60' and Service_type in ('T2') and DateDiff(dd ,CONVERT(VARCHAR(10),RECEIPT_DT,120),getdate())>7 and Cost_type in ('W6','') ) 'Over 7 Days' from W_JOB_HEADER_USG105 J join B_MINOR M on J.Service_type=M.Minor_cd and M.Major_cd='WA003'and J.Service_type in ('T2')"> </asp:SqlDataSource> <trirand:JQGrid runat="server" ID="JQGrid1" DataSourceID="SqlDataSource1" Height="100%" KeyboardNavigation="False" Width="1310px" AutoWidth="True" onprerender="JQGrid1_PreRender" > <TreeGridSettings Enabled="True" /> <ViewRowDetailsDialogSettings Caption="Pending Jobs Report" /> <AppearanceSettings Caption="Pending Jobs" /> <Columns> <trirand:JQGridColumn DataField="SVC Type" Searchable="False" Sortable="False" TextAlign="Center" CssClass= "ui-jqgrid" /> <trirand:JQGridColumn DataField="WTY" TextAlign="Center" /> <trirand:JQGridColumn DataField="Total" TextAlign="Center" /> <trirand:JQGridColumn DataField="0~3 Days" TextAlign="Center" /> <trirand:JQGridColumn DataField="4~7 Days" TextAlign="Center"> </trirand:JQGridColumn> <trirand:JQGridColumn DataField="Over 7 Days" TextAlign="Center" > </trirand:JQGridColumn> </Columns> <SearchDialogSettings Draggable="False" /> </trirand:JQGrid> </form> </body> </html>
The resut comes as below