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

NULL Column and Grouping

2 Answers 30 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Mike
Top achievements
Rank 1
Mike asked on 31 Jul 2008, 01:34 PM
Let's say I have two rows in my grid.  They have 8 columns, 1 column returns no data, actually a null value.  When I group on that column the rows get duplicated, so there are two rows in each grouping for a total of four rows.

I can do a case statement in my SQL and assign a value to the null column which removes the duplicate when grouped. 

But this should not be a SQL issue and I thought you should know that this is happening in your Grid when Grouping on a null column.

2 Answers, 1 is accepted

Sort by
0
Yavor
Telerik team
answered on 04 Aug 2008, 07:32 AM
Hi George,

Basically, with a null value, the grid will put all records with null values in one group. This is demonstrated in the code sample attached to this message.

Kind regards,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Mike
Top achievements
Rank 1
answered on 13 Sep 2008, 06:43 PM
Thank you!
Tags
Grid
Asked by
Mike
Top achievements
Rank 1
Answers by
Yavor
Telerik team
Mike
Top achievements
Rank 1
Share this question
or