or
PO Customer Order Product QtyAlpha Apple 30456 Napkins 400Alpha Apple 30457 Pizza 200Alpha Apple 30458 Schlitz 400Beta Google 20001 Pizza 400Beta Google 20002 Schlitz 200<telerik:RadListView> <ItemTemplate> <asp:Label ID="lbl_PO" /> <asp:Label ID="lbl_Customer" /> <telerik:RadGrid> <telerik:GridBoundColumn DataField="Product" /> <teleirk:GridBoundColumn DataField="Qty" /> </telerik:RadGrid> </ItemTemplate></telerik:RadListView>PO: AlphaCustomer: Apple______________________| Order | Product | Qty |______________________
| 30456 | Napkins | 400 |______________________| 30457 | Pizza | 200 |______________________| 30458 | Schlitz | 400 |______________________PO: BetaCustomer: Google ______________________| Order | Product | Qty |______________________| 20001 | Pizza | 400 |______________________| 20002 | Schlitz | 200 |______________________
<script type="text/javascript"> function onRequestStart(sender, args) { if ( (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0) || (args.get_eventTarget().indexOf("ExportToPdfButton") >= 0) ) { alert(args.get_eventTarget()); args.set_enableAjax(false); } }</script><telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" UpdatePanelsRenderMode="Inline"> <ClientEvents OnRequestStart="onRequestStart" /> <AjaxSettings>... <telerik:AjaxSetting AjaxControlID="ReportResultsGrid"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="ReportResultsGrid" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings></telerik:RadAjaxManager><telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default"></telerik:RadAjaxLoadingPanel><telerik:RadGrid ID="ReportResultsGrid" runat="server" AllowPaging="True" AllowSorting="True" Height="100%" Width="98%" CellSpacing="0" GridLines="None" ShowGroupPanel="True" OnColumnCreated="ReportResultsGrid_ColumnCreated" AutoGenerateColumns="False" OnNeedDataSource="ReportResultsGrid_NeedDataSource" PageSize="20" OnItemCreated="ReportResultsGrid_ItemCreated"> <ExportSettings OpenInNewWindow="True" ExportOnlyData="True" HideStructureColumns="True" IgnorePaging="True"> <Pdf BorderType="NoBorder" ForceTextWrap="true" PageTopMargin="1.5in" PageBottomMargin="0.5in" PageLeftMargin="0.1in" PageRightMargin="0.1in"> </Pdf> </ExportSettings> <ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True" ReorderColumnsOnClient="True"> <Scrolling UseStaticHeaders="True" /> </ClientSettings> <MasterTableView PageSize="25" CommandItemDisplay="TopAndBottom"> <CommandItemSettings ShowAddNewRecordButton="False" ShowExportToExcelButton="True" ShowExportToPdfButton="True" ShowRefreshButton="False" /> <Columns>...[grid bound columns]... </Columns> <PagerStyle Position="TopAndBottom" AlwaysVisible="true" /> <CommandItemStyle HorizontalAlign="Left" /> </MasterTableView> <PagerStyle PageSizes="10;25;50;100;200" Position="TopAndBottom" /></telerik:RadGrid>protected void ReportResultsGrid_ItemCreated(object sender, GridItemEventArgs e){ if (e.Item is GridPagerItem) { var dropDown = (RadComboBox)e.Item.FindControl("PageSizeComboBox"); var totalCount = ((GridPagerItem)e.Item).Paging.DataSourceCount; var sizes = new Dictionary<string, string>() { {"10", "10"}, {"25", "25"}, {"50", "50"} }; if (totalCount > 100) { sizes.Add("100", "100"); } if (totalCount > 200) { sizes.Add("200", "200"); } sizes.Add("All", totalCount.ToString()); dropDown.Items.Clear(); foreach (var size in sizes) { var cboItem = new RadComboBoxItem() { Text = size.Key, Value = size.Value }; cboItem.Attributes.Add("ownerTableViewId", e.Item.OwnerTableView.ClientID); dropDown.Items.Add(cboItem); } dropDown.FindItemByValue(e.Item.OwnerTableView.PageSize.ToString()).Selected = true; }}protected void ReportResultsGrid_ColumnCreated(object sender, GridColumnCreatedEventArgs e){ if (e.Column is GridBoundColumn) { GridBoundColumn col = (GridBoundColumn)e.Column; if (col.UniqueName == "ID") { col.Visible = false; } }}protected void ReportResultsGrid_NeedDataSource(object sender, GridNeedDataSourceEventArgs e){ DataTable results = (DataTable)Session[ListReportResultsName]; ReportResultsGrid.DataSource = results;}