Columns ForeignKey Aggregate problem

[Rafał]

I have a some problem with Foreign Key column.
I use MVC 3 and Ajax DataBInding.
I would like to use Aggregate and ClientGroupHeaderTemplate and write count of rows, but didn't work.

this is my code
columns.ForeignKey(o => o.ID_Document_Status, (System.Collections.IEnumerable)ViewData["Statusy"], "ID", "Name_")
                .Width(50)
                .ClientTemplate("<strong><#= Status #></strong>")
                .Title("Status")
                .Aggregate(a => a.Count())
                .ClientGroupHeaderTemplate("<#= Count #>");.


please help

best regards
rafal

[Pechka]

Hi,

few tips:
1) If you have collection passed to the Grid like this @(Html.Telerik().Grid<SomeModel>(Model) ...)
 -remove the Model and let the Grid perform an Ajax request. Or you should define GroupHeaderTemplate
2) Make sure you have grouped the Grid by the ID_Document_Status column - otherwise the Grouping header for that particular column wont be displayed

[Rafał]

This is my full code grid
       

@(Html.Telerik().Grid<LPI_Raportowanie.Models.ZPIModel>()
        .Name("Grid")
        .Columns(columns =>
        {
            columns.Bound(o => o.ID).Width(20).Visible(false);
            columns.Bound(o => o.NrRefZPI).Width(50).Title("Numer ZPI")
            columns.Bound(o => o.NameOfProjektIT).Width(300).Title("Nazwa projektu").Sortable(false);
            columns.ForeignKey(o => o.ID_Document_Status, (System.Collections.IEnumerable)ViewData["Statusy"], "ID", "Name_")
                .Width(50)
                .ClientTemplate("<strong><#= Status #></strong>")
                .Title("Status")
                .Aggregate(a => a.Count())
                .ClientGroupHeaderTemplate("<#= Count #>");
        })
        .DataBinding(dataBinding => dataBinding.Ajax().Select("_AjaxBinding", "Report"))
        .Sortable()
        .Scrollable(x => x.Height("500px"))
        .Filterable()
        .Groupable(settings => settings.Groups(groups => groups.Add(o => o.ID_Document_Status)).Visible(true))
 )

[Rafał]

whether anyone know what is wrong ?