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

Grouping Problem

0 Answers 52 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Cristian
Top achievements
Rank 1
Cristian asked on 13 Oct 2011, 07:35 PM
Hi I'm working with telerik radcontrols for asp.net ajax q2 2010, I'm using the grouping property of the grid by following the next sample demo. http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/outlookstyle/defaultcs.aspx

I'm grouping the grid's item by date but instead of getting the result like the demo I have groups of 1 items no matter if the date is the same. And I want to have all items of the same date in one group like the demo.

This is the code of my grid
<telerik:RadGrid 
                             ID="rgSolic"
                             runat="server" 
                             Skin="Sunset"  Width="850px"                          
                             AutoGenerateColumns="False"                                                                                               
                             AllowPaging="True"
                             Culture="es-MX"
                             GridLines="None" HorizontalAlign="Center"
                             AllowSorting="True" onitemcommand="rgSolic_ItemCommand"  
                                onitemdatabound="rgSolic_ItemDataBound" 
                                onselectedindexchanged="rgSolic_SelectedIndexChanged" 
                                onpageindexchanged="rgSolic_PageIndexChanged" 
                                onneeddatasource="rgSolic_NeedDataSource"  >
                                  
                                 
                                   
                        
                             <GroupingSettings CaseSensitive="false" />
                                <MasterTableView                         
                                    Width="850px" 
                                    AllowPaging ="true"
                                    NoMasterRecordsText="No hay registros para mostrar"                         
                                    DataKeyNames="fiIdSolicitud" 
                                    ClientDataKeyNames="fiIdSolicitud" AllowMultiColumnSorting="true" 
                                    Font-Size="Smaller">
                                       
                                    <CommandItemSettings  ExportToPdfText="Export to Pdf">
                                    </CommandItemSettings>
                                    <PagerStyle  Mode="NextPrevAndNumeric" PagerTextFormat="Cambiar Página: {4} &nbsp;Mostrando Página {0} de {1}, elementos {2} de {3} al {5}." 
                                                FirstPageToolTip="" LastPageToolTip="" NextPagesToolTip="" NextPageToolTip="" 
                                                PageSizeLabelText="" PrevPagesToolTip="" PrevPageToolTip="" />
                                             <GroupByExpressions>
      <telerik:GridGroupByExpression>
        <SelectFields>
          <telerik:GridGroupByField FieldName="fdFchRegMenor" HeaderText="Fecha de registro"  FormatString="{0:D}" />
          
        </SelectFields>
        <GroupByFields>
          <telerik:GridGroupByField FieldName="fdFchRegMenor" SortOrder="Ascending"  FormatString="{0:D}" />
        </GroupByFields>
      </telerik:GridGroupByExpression>
    </GroupByExpressions>
  
  
                                    <Columns>
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  
                                            HeaderText="Folio" DataField="Solicitud.fiIdSolicitud"  
                                            UniqueName="fiIdSolicitud">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  
                                            HeaderText="Circuito" DataField="Solicitud.fiCircuito"  UniqueName="Circuito">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  
                                            HeaderText="Estado" DataField="Solicitud.fiEstado"  UniqueName="nom_edo">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  
                                            HeaderText="Ciudad" DataField="Solicitud.fiCiudad"  UniqueName="nom_cd">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>                                        
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  HeaderText="Fecha de registro"  DataField="fdFchRegMenor"  UniqueName="fdFchRegMenor" DataFormatString="{0:d}">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
  
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  
                                            HeaderText="Madre/Padre"  DataField="Solicitud.fcNomEmpleado"  
                                            UniqueName="PADRE">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
  
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  
                                            HeaderText="Expediente "  DataField="Solicitud.fiExpEmpleado"  
                                            UniqueName="EXPEDIENTE" Visible="False">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
  
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  
                                            HeaderText="Menor"  DataField="fcNomMenor"  UniqueName="MENOR">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  HeaderText="Sexo Menor"  DataField="fiSexoMenor"  UniqueName="fiSexoMenor">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  HeaderText="Fch. Nacimiento"  DataField="fdFchNacMenor"  UniqueName="fdFchNacMenor" DataFormatString="{0:d}">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
                                         <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center"  
                                            HeaderText="Adscripción"  DataField="Area.nom_area"  
                                            UniqueName="Adscripcion" Visible="False">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
  
                                          <telerik:GridBoundColumn DataField="fiIdMenor" HeaderText="Id MEnor" 
                                            UniqueName="columnIdM" Visible="False">
                                        </telerik:GridBoundColumn>
  
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" 
                                            HeaderText="Edad"  UniqueName="EDAD">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn HeaderStyle-HorizontalAlign="Center" 
                                            HeaderText="Estatus"  DataField="Solicitud.CTEdoSolicitud.fcDescEdoSol"  
                                            UniqueName="fcDescEdoSol">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridBoundColumn>
                                        <telerik:GridButtonColumn HeaderStyle-HorizontalAlign="Center" 
                                            HeaderText="Solicitud" CommandName="Solicitud"   ButtonType="ImageButton" 
                                            ImageUrl = "~/imgs/report.gif"  >
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridButtonColumn>
                                        <telerik:GridButtonColumn HeaderStyle-HorizontalAlign="Center" 
                                            HeaderText="Documentos" CommandName="Documentos"   ButtonType="ImageButton"  
                                            ImageUrl = "~/imgs/documents.png"  >
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridButtonColumn>
                                        <telerik:GridButtonColumn HeaderStyle-HorizontalAlign="Center" 
                                            HeaderText="Observaciones" CommandName="Observaciones"   
                                            ButtonType="ImageButton" ImageUrl = "~/imgs/exclamation.png" >
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </telerik:GridButtonColumn>
                                       
                                    </Columns>
                                </MasterTableView>
                                    <ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True">
                                    <Selecting AllowRowSelect="true" />
                                        <Resizing AllowColumnResize="True" AllowRowResize="True" 
                                            ClipCellContentOnResize="False"                                              
                                            EnableRealTimeResize="True" ResizeGridOnColumnResize="True" 
                                            ShowRowIndicatorColumn="False" />
                                    </ClientSettings>
                                    <HeaderStyle HorizontalAlign="Center" />
                                    <StatusBarSettings LoadingText="Cargando..." ReadyText="Listo" />
                            </telerik:RadGrid>


I'm attaching an image of what I'm getting.

Best regards
Cristian.

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Cristian
Top achievements
Rank 1
Share this question
or