or
...and I don't know which property/properties to modify to get the desired change?
Cheers in advance,
Gordopolis
Grid.ExportSettings.IgnorePaging = true;Grid.ExportSettings.ExportOnlyData = true;Grid.ExportSettings.OpenInNewWindow = true;Grid.ExportSettings.FileName = "filename"; Grid.MasterTableView.ExportToExcel();
Grid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;<telerik:RadGrid ShowGroupPanel ="false" AutoGenerateColumns ="false" ID ="Grid" AllowFilteringByColumn ="False" AllowSorting ="False" ShowFooter ="True" runat ="server" GridLines ="Both" AllowPaging ="false" EnableLinqExpressions ="false" CssClass ="RadGridCustomClass" OnPreRender ="Grid_PreRender" OnExcelMLExportRowCreated="Grid_ExcelMLExportRowCreated" OnGridExporting ="Grid_GridExporting" OnExcelMLExportStylesCreated="Grid_ExcelMLExportStylesCreated" OnItemDataBound ="Grid_ItemDataBound"> <PagerStyle Mode="NextPrevAndNumeric" /> <MasterTableView ShowGroupFooter ="true" HeaderStyle-Font-Bold ="true" HeaderStyle-ForeColor ="#333333" AllowMultiColumnSorting ="false"> <Columns> <telerik:GridBoundColumn DataField ="SubCategory" ItemStyle-HorizontalAlign ="Center" UniqueName ="REP013_FuellingCategoryHeaderText" FooterStyle-HorizontalAlign ="Center" FooterStyle-Font-Bold ="true" HeaderStyle-HorizontalAlign ="Center" > </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate ="Sum" DataField ="Total_Fuel_Litres" DataType ="System.Int32" UniqueName ="REP013_TotalFuelHeaderText" DataFormatString ="{0:###,###.##}" ItemStyle-HorizontalAlign ="Center" FooterStyle-HorizontalAlign ="Center" FooterStyle-Font-Bold ="true" HeaderStyle-HorizontalAlign ="Center" FooterText ="<%$ Resources:MyGlobals, REP013_TotalFuelFooterText%>"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate ="Avg" DataField ="Bio_Content" DataFormatString ="{0:0.0%}" UniqueName ="REP013_BioContentHeaderText" ItemStyle-HorizontalAlign ="Center" FooterStyle-HorizontalAlign ="Center" FooterStyle-Font-Bold ="true" HeaderStyle-HorizontalAlign ="Center" > </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate ="Sum" DataField ="Bio_Diesel_Litres" DataFormatString ="{0:###,###}" UniqueName ="REP013_BioDieselHeaderText" ItemStyle-HorizontalAlign ="Center" FooterStyle-HorizontalAlign ="Center" FooterStyle-Font-Bold ="true" HeaderStyle-HorizontalAlign ="Center" FooterText ="<%$ Resources:MyGlobals, REP013_BioDieselFooterText%>"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate ="Sum" DataField ="Standard_Diesel_Litres" DataFormatString ="{0:###,###}" UniqueName ="REP013_StandardDieselHeaderText" ItemStyle-HorizontalAlign ="Center" FooterStyle-HorizontalAlign ="Center" FooterStyle-Font-Bold ="true" HeaderStyle-HorizontalAlign ="Center" FooterText ="<%$ Resources:MyGlobals, REP013_StandardDieselFooterText%>"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Aggregate ="Sum" DataField ="CO2_Tonnes" DataFormatString ="{0:###,##0.0}" UniqueName ="REP013_CO2QuantityHeaderText" ItemStyle-HorizontalAlign ="Center" FooterStyle-HorizontalAlign ="Center" FooterStyle-Font-Bold ="true" HeaderStyle-HorizontalAlign ="Center" FooterText ="<%$ Resources:MyGlobals, REP013_CO2QuantityFooterText%>"> </telerik:GridBoundColumn> </Columns> <GroupByExpressions> <telerik:GridGroupByExpression> <SelectFields> <telerik:GridGroupByField FieldName="Category" /> </SelectFields> <GroupByFields> <telerik:GridGroupByField FieldName="Category" SortOrder="Ascending" /> </GroupByFields> </telerik:GridGroupByExpression> </GroupByExpressions> </MasterTableView> <ClientSettings AllowDragToGroup ="false" /> <GroupingSettings ShowUnGroupButton ="false" /> </telerik:RadGrid><telerik:RadListView ID="RadListView1" runat="server" AllowPaging="True" ItemPlaceholderID="PlaceHolder1" Skin="listview_2" EnableEmbeddedSkins="false" OnItemDataBound="RadListView1_ItemDataBound" AllowCustomPaging="true" DataKeyNames="id,filenameextension,typeAbbr,title,fidTimeOfDay" OnNeedDataSource="RadListView1_NeedDataSource" OnPageIndexChanged="RadListView1_PageIndexChanged" OnPageSizeChanged="RadListView1_PageSizeChanged" > <LayoutTemplate> <div class="RadListView RadListViewFloated RadListView_Windows7"> <telerik:RadDataPager ID="RadDataPager1" runat="server" PageSize="25" PagedControlID="RadListView1" BorderWidth="0" OnFieldCreated="RadDataPager1_FieldCreated" CssClass="dataPagerClass"> <Fields> <telerik:RadDataPagerButtonField FieldType="FirstPrev" /> <telerik:RadDataPagerButtonField FieldType="Numeric" PageButtonCount="5" /> <telerik:RadDataPagerButtonField FieldType="NextLast" /> <telerik:RadDataPagerPageSizeField PageSizeText="Page size: " /> <telerik:RadDataPagerGoToPageField CurrentPageText="Page: " TotalPageText="of" SubmitButtonText="Go" TextBoxWidth="15" /> <telerik:RadDataPagerTemplatePageField> <PagerTemplate> <b>Total Number of Assets Found: <asp:Label runat="server" ID="TotalItemsLabel" Text="<%# Container.Owner.TotalRowCount%>" /> </b> </PagerTemplate> </telerik:RadDataPagerTemplatePageField> </Fields> </telerik:RadDataPager> <asp:PlaceHolder ID="PlaceHolder1" runat="server" /> </div> </LayoutTemplate> <ItemTemplate> <div style="float: left; width: 162px; height: 200px; background-color: White;"> <asp:Panel ID="myThumb" runat="server" CssClass="myClass" Style="border: 0; white-space: normal; padding: 5px 4px 25px 2px; text-align: center; width: 160px; background-color: white; margin-left: 2px;"> <div style="width: 150px; height: 150px; margin-left: 2px;"> <asp:HyperLink ID="HyperLink1" runat="server"> <telerik:RadBinaryImage ID="RadBinaryImage1" runat="server" AutoAdjustImageControlSize="false" CssClass="myClass" ImageUrl='<%# Eval("thumbUrl") %>' AlternateText="Click to view preview" ToolTip="Click to view preview" /> </asp:HyperLink><br /> </div> <asp:CheckBox ID="ChkImage" runat="server" Style="float: left; padding-top: 5px" /><small><asp:HyperLink ID="lnkAsset1" runat="server" Visible="false" Style="float: left; padding-top: 5px; text-decoration: none; font-weight: normal; font-size: 7pt;"> </asp:HyperLink><asp:HyperLink ID="lnkAsset2" runat="server" Style="float: left; text-decoration: none; font-weight: normal; font-size: 7pt;"> </asp:HyperLink><asp:HyperLink ID="lnkAsset3" runat="server" Style="float: left; padding-left: 20px; text-decoration: none; font-weight: normal; font-size: 7pt;"></asp:HyperLink></small><br /> <asp:HiddenField ID="hiddenAssetId" Value='<%# Eval("id") %>' runat="server" /> </asp:Panel> </div> </ItemTemplate> <EmptyDataTemplate> No Assets Found </EmptyDataTemplate></telerik:RadListView>