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.
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.