How do I merge the first column of jqgrid (html table)into one cell up to n number of rows and remove all the repeated tds'

Question

0.00/5 (No votes)

See more:

Hi,

I have used jqgrid to show a report which is generated dynamically. In the first column I get repeated values. I need to remove all the repeated values and their cells except second row first column, then I need it to span across n number of rows using "row span".

How can I do it, any other technique is welcome.

I wanted to post images here but don't know how. Please help.

Posted 5-Oct-15 23:38pm

ganesh.dks

Updated 5-Oct-15 23:45pm

Palash Mondal_

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ganesh.dks · Accepted Answer · 2015-10-28T01:47:00

Hi,
I got the following solution. I wrote this function for my problem. In order for this to work I have to retain the value of the grid and kept refreshing it with the data whenever I had a change in UI. It works very well. For any details please comment.

JavaScript

function groupData() {
                var table = document.getElementById("list_frozen");
                var spansize = table.rows.length - 2;
                for (var i = 2, row; row = table.rows[i]; i++) {
                    if (i < table.rows.length - 1) {
                        for (var j = 0, col; col = row.cells[j] && j < 1; j++) {
             //iterate through columns
             //columns would be accessed using the "col" variable 
             //assigned in the for loop
                            row.deleteCell(j);
                        }
                    }
                }
   $("#list_frozen tbody tr:nth-child(2) > td:nth-child(1)").attr('rowspan', spansize);
}