This is a migrated thread and some comments may be shown as answers.

Cross Tab

11 Answers 349 Views

GridView

This is a migrated thread and some comments may be shown as answers.

Ganeshram asked on 15 Mar 2008, 01:38 PM

Support,
I'm trying to acheive cross tab results using RadGridview.Please let me know whether this is acheivable using RadGridView.Appreciate if you can provide me a sample.

Actual data
Basicpay           TotalCash        Percentil
10000                20000                10
20000                30000                20
30000                70000                50
50000                80000                90

Cross Tab Result
                        10        20        50        90
Basic Pay        1000    2000    3000    4000
Total Cash       3000    4000    5000    6000

Thanks in advance.

-Cheers
G

11 Answers, 1 is accepted

answered on 17 Mar 2008, 03:12 PM

Hi Ganeshram,

Thank you for writing.

Currently, the RadGridView for WinForms does not support the "CrossTab" transformation. However, you can manually do that by transforming your dataset and binding the grid to a new table. For example, please review the function provided below:

    
            public DataTable ConvertToCrossTab(DataTable table)  
        
            {  
        
                DataTable newTable = new DataTable();  
        
                for (int r = 0; r <= table.Rows.Count; r++)  
        
                {  
        
                    newTable.Columns.Add(r.ToString());  
        
                }  
        
                for (int c = 0; c < table.Columns.Count; c++)  
        
                {  
        
                    DataRow row = newTable.NewRow();  
        
                    object[] rowValues = new object[table.Rows.Count + 1];  
        
                    rowValues[0] = table.Columns[c].Caption;  
        
                    for (int r = 1; r <= table.Rows.Count; r++)  
        
                    {  
        
                        rowValues[r] = table.Rows[r-1][c].ToString();     
        
                    }  
        
                    row.ItemArray = rowValues;  
        
                    newTable.Rows.Add(row);  
        
                }  
        
                return newTable;  
        
            }

You should consider that the RadGridView is optimized to show a large number of rows, not columns. So if you transform table with a lot of rows (resulting in a dataset with a lot of columns) you could expect some performance decrease when showing it in a RadGridView.

I hope this was helpful. Do not hesitate to contact me if you have other questions.

All the best,
Martin Vasilev
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

answered on 08 Jan 2009, 10:05 PM

I got confused since this was the Winforms forum. Is there a plan for Crosstab on Gridview?

I think it might be really valuable to have a generic control (a datasource?) to provide this functionality. There are a number of places where I'd find it useful to just declaratively bind to my data, but sideways. I already see a bunch of controls in your toolbox that would be better for the option.

It's an idea.

ps. For the other people who might search on this, some do-it-by-hand options:
http://stackoverflow.com/questions/320895/using-linq-to-create-crosstab-results
http://stackoverflow.com/questions/167304/is-it-possible-to-pivot-data-using-linq