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
>