Grouped Data not coming on same page when paging is allowed

[Somesh]

Telerik Team,

I have a urgent requirement. I have created a dashboard implementing RadGrid. Grid allowing all the feature like grouping, sorting, filtering etc.

RadGrid which I am implementing is having paging, meaning AllowPaging=”true”. Problem began at production server when all grouped data was scattered in different pages. My Client want all the group summary should come on same page so that they can see Total Quantity, Amount and other high level picture at once.

How can I achieve this, I mean keep the paging and show all grouped data togather.

If I am setting AllowPaging="Flase", Grid performance is very very poor. Even applying grouping/sorting taking more than 2 minutes. We have almost 20,000 records and may grow higher.

This is very urgent as product is already uploaded at client server and UAT is about to start.

Below I am attaching my grid HTML:

<telerik:RadGrid ID="RGVendor"
GridLines="none"
runat="server"
EnableAJAX="true"
Skin="Vista"
ShowStatusBar="True"
CellSpacing="0"
AllowSorting="True"
ShowFooter="True"
Width="99%"
Height="500px"
ShowGroupPanel="True"
OnItemCommand="RGVendor_ItemCommand"
OnColumnCreated="RGVendor_ColumnCreated"
AllowFilteringByColumn="True"
OnNeedDataSource="RGVendor_NeedDataSource"
OnInit="RGVendor_Init"
EnableViewState="true"
AllowPaging="True"
PageSize="25"
OnCustomAggregate="RGVendor_CustomAggregate"
>
<PagerStyle Mode="Advanced" AlwaysVisible="true" />
<GroupingSettings GroupContinuesFormatString="" GroupContinuedFormatString="" CaseSensitive="False" ShowUnGroupButton="True" />
<ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">
<Excel Format="ExcelML" />
</ExportSettings>
<MasterTableView
CommandItemDisplay="Top"
GroupsDefaultExpanded="false"
Width="98%"
Font-Size="8"
TableLayout="Fixed"
ShowGroupFooter="true"
AllowFilteringByColumn="True"
GroupLoadMode="Client"  >
<CommandItemSettings ExportToPdfText="Export to PDF" ShowExportToExcelButton="false"
ShowAddNewRecordButton="false"></CommandItemSettings>
<CommandItemTemplate>
<telerik:RadToolBar runat="server" ID="RadToolBar1" Skin="Vista" OnButtonClick="RadToolBar1_ButtonClick">
<Items>
<telerik:RadToolBarButton Text="Apply filter" CommandName="FilterRadGrid" ImageUrl="<%#GetFilterIcon() %>"
ImagePosition="Right" />
</Items>
</telerik:RadToolBar>
</CommandItemTemplate>
<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
</RowIndicatorColumn>
<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
</ExpandCollapseColumn>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column">
</EditColumn>
</EditFormSettings>
</MasterTableView>
<FilterMenu EnableImageSprites="False">
</FilterMenu>
<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">
</HeaderContextMenu>
<ExportSettings ExportOnlyData="true"  IgnorePaging="true" Excel-Format="ExcelML">
<Excel Format="ExcelML"></Excel>
</ExportSettings>
<ClientSettings AllowColumnsReorder="false" AllowDragToGroup="True" DataBinding-EnableCaching="true" >
<Resizing AllowColumnResize="True" ResizeGridOnColumnResize="true" />
<Scrolling AllowScroll="True" SaveScrollPosition="true" EnableVirtualScrollPaging="True" UseStaticHeaders="true" ></Scrolling>
</ClientSettings>
<HeaderStyle Width="120px" />
</telerik:RadGrid>

[Pavlina]

Hi Somesh,

Unfortunately the desired functionality can not be achieved with the current implementation of RadGrid control. You can refer to this forum thread for additional information on this matter. Please excuse us for the inconvenience caused.

All the best,
Pavlina
the Telerik team