tmondelli on setGroupHeaders error when there is more than one column header

Thu, 27 Mar 2014 16:55:28 +0200

What I'm really after is whether or not there will be the ability to create mulitple group header lines within the API for jqGrid. If not, then I will continue on with the hack that I am creating now.

tony on setGroupHeaders error when there is more than one column header

Wed, 26 Mar 2014 07:26:03 +0200

Hello,

..but it is not working great for me.

What you mean with this?

Regards

tmondelli on setGroupHeaders error when there is more than one column header

Tue, 25 Mar 2014 18:32:03 +0200

I'm looking for a better resolution to the same problem. I need the ability to create multiple levels of group headers for reports. I've asked on stacked overflow and I received an answer from Oleg (link below), but it is not working great for me. Is there any updates on jqGrid allowing multi-headers?

Stack Overflow

Oleg's example report

tony on setGroupHeaders error when there is more than one column header

Mon, 24 Feb 2014 12:34:49 +0200

Hello,

Thank you for finding this.

Can you please prepare for me (or publish online - use source code not min one) simple test case ?

Thanks

Tony

jmjimenez on setGroupHeaders error when there is more than one column header

Sat, 22 Feb 2014 15:15:02 +0200

I don't know if it's an error, but I would like to share this situation with you:

If you call setGroupHeaders more than once (for example, it's a common situation in jpPivot when there is more than one yDimension) you need to configure all headers to have the same amount of columns. For example:

    $(tblSelect).jqGrid('setGroupHeaders', {
                        useColSpanStyle: true,
                        groupHeaders:[
                                {startColumnName: 'G01G01C01', numberOfColumns: 8, titleText: '2012'},
                                {startColumnName: 'G02G01C01', numberOfColumns: 8, titleText: '2013'}
                        ]
                });

                $(tblSelect).jqGrid('setGroupHeaders', {
                        useColSpanStyle: true,
                        groupHeaders:[
                                {startColumnName: 'G01G01C01', numberOfColumns: 4, titleText: 'Trim 1'},
                                {startColumnName: 'G01G03C01', numberOfColumns: 2, titleText: 'Trim 2'},
                                {startColumnName: 'G01T01',    numberOfColumns: 2, titleText: ''},
                                {startColumnName: 'G02G01C01', numberOfColumns: 4, titleText: 'Trim 1'},
                                {startColumnName: 'G02G03C01', numberOfColumns: 2, titleText: 'Trim 2'},
                                {startColumnName: 'G02T01',    numberOfColumns: 2, titleText: ''},
                        ]
                });

                $(tblSelect).jqGrid('setGroupHeaders', {
                        useColSpanStyle: true,
                        groupHeaders:[
                                {startColumnName: 'G01G01C01', numberOfColumns: 2, titleText: 'Enero'},
                                {startColumnName: 'G01G02C01', numberOfColumns: 2, titleText: 'Febrero'},
                                {startColumnName: 'G01G03C01', numberOfColumns: 2, titleText: 'Abril'},
                                {startColumnName: 'G01T01', numberOfColumns: 2, titleText: 'Total 2012'},
                                {startColumnName: 'G02G01C01', numberOfColumns: 2, titleText: 'Enero'},
                                {startColumnName: 'G02G02C01', numberOfColumns: 2, titleText: 'Febrero'},
                                {startColumnName: 'G02G03C01', numberOfColumns: 2, titleText: 'Abril'},
                                {startColumnName: 'G02T01', numberOfColumns: 2, titleText: 'Total 2013'}
                        ]
                });

I have created 3 levels of headers:

The first one is per Year
The second one is for Trimestrer
The last one is for Month and totals per year

You can see for Trimestrer headers I must create 2 dummy columns to fill the "total" columns. So, this header has 16 columns. If I don't define the dummy columns, the headers are rendered wrong.

thanks for your great work!!

jQuery Grid Plugin - jqGrid - Topic: setGroupHeaders error when there is more than one column header

tmondelli on setGroupHeaders error when there is more than one column header

tony on setGroupHeaders error when there is more than one column header

tmondelli on setGroupHeaders error when there is more than one column header

tony on setGroupHeaders error when there is more than one column header

jmjimenez on setGroupHeaders error when there is more than one column header