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

Group by a substring of column

4 Answers 221 Views

GridView

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

4 Answers, 1 is accepted

answered on 04 Feb 2009, 09:14 AM

Infact,

Pradeep proposed you to set parameter of formatString in the Column definition, not in the GroupBy expression ;)

ok, You cannot set a GroupBy with a substring in a column.

Here is a sample of. (You should read documentation about aggregate key words)

    
            ....GroupByExpressions.Add("Col1 as Brand format \"{1} - \", sum(ColWithDecimal) as Total format \"{0}: {1} Units | \" Group By Col1");

So for me to do this there is two ways.
If the format string in the date column is not the same as you need for your group by expression, you need an other column, with a different formatstring.

If it's the same format, keep it and group by expression should be

    
            ....GroupByExpressions.Add("column3 as Date format \"{1}\" Group By column3");

As you can read on it, {0} is the "as" name : here the 'Date' word. And {1} is the value in the column.

This is correct expression

    
            "column3 as Date format \"{0} is {1}\" Group By column3"

This is incorrect expression

    
            "column3 as Date To use format \"{0} is {1}\" Group By column3"

No space in the name ^^

If you need a specific presentation, you shall do this:

    
            "column3 as Date format \"My Specific presentation: {1}\" Group By column3"

Please, read documentation next time :)

Some questions? Don't hesitate.

Best regards,

Fabien

EDIT:
I forgot to give you an example of formatStirng in the column (I don't use IDE to create it but this is the same thing)

    
                            GridViewDecimalColumn Country_Column = new GridViewDecimalColumn("FR", country.Code); 
        
                            Country_Column.HeaderText = "France"; 
        
                            Country_Column.MinWidth = 40; 
        
                            Country_Column.FormatString = "{0:N0} Units"; 
        
                            Country_Column.DataType = typeof(int); 
        
                            Country_Column.TextAlignment = ContentAlignment.TopRight; 
        
                            Country_Column.DecimalPlaces = 0; 
        
                            Country_Column.Minimum = 0; 
        
                            Country_Column.Step = 500; 
        
                            Country_Column.ThousandsSeparator = true; 
        
                            pRadGridView.MasterGridViewTemplate.Columns.Add(Country_Column);