grid sumary with dynamic data
Thanks for using Syncfusion controls.
Query : “How to summarize the auto generated columns?”
Your requirement can be achieved by the dataBound event of ejGrid. This event triggers during initial rendering of Grid. Also we can get the column names in gridInstance object. Using that we add the summary rows and enable the summary through setModel.
Please find the code example and sample:
|
<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
<ej:Grid ID="FlatGrid" runat="server" AllowSorting="True" DataSourceID="SqlData" AllowGrouping="true" OnServerWordExporting="FlatGrid_ServerWordExporting" OnServerPdfExporting="FlatGrid_ServerPdfExporting" OnServerExcelExporting="FlatGrid_ServerExcelExporting" AllowPaging="True" AllowFiltering="True" > <ToolbarSettings ShowToolbar="true" ToolbarItems="excelExport,wordExport,pdfExport"></ToolbarSettings> <FilterSettings FilterType="Excel"></FilterSettings> <ClientSideEvents DataBound="databound" /> </ej:Grid> <asp:SqlDataSource ID="SqlData" runat="server" ConnectionString="<%$ ConnectionStrings:NORTHWNDConnectionString %>" SelectCommand="SELECT * FROM [Territories]"></asp:SqlDataSource> <script type="text/javascript"> function databound(args) { this.model.summaryRows.push({ title: "Sum", summaryColumns: [{ summaryType: ej.Grid.SummaryType.Sum, displayColumn: this.model.columns[2].headerText, dataMember: this.model.columns[2].headerText, format: "{0:C2}", prefix: "Sum =" }] }); $("#MainContent_FlatGrid").ejGrid("model.showSummary", true); } </script> |
Sample: http://www.syncfusion.com/downloads/support/forum/121522/ze/WebApplication21-1223074639
Query : “Export to excel”
We have tried with our sample and we did not face any issues while exporting to the Excel. While exporting, we suggest you to convert the datasource to list of data.
Please find the code example :
|
protected void FlatGrid_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e) { ExcelExport exp = new ExcelExport(); DataView data = (DataView)SqlData.Select(new DataSourceSelectArguments()); IList data1 = data; DataTable dt = data.Table; var emp = (from DataRow row in dt.Rows
select new Order { TerritoryID = Convert.ToInt32(row["TerritoryID"]), TerritoryDescription = row["TerritoryDescription"].ToString(), RegionID = Convert.ToInt32(row["RegionID"]), }).ToList(); IWorkbook workbook = exp.Export(FlatGrid.Model, (IEnumerable)emp, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime", true); exp.Export(FlatGrid.Model, (IEnumerable)emp, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime", false, workbook, MultipleExportType.AppendToSheet, "Flat Grid"); |
Please provide the following details us to find out the root cause of the issue.
Please try the attached sample and still if you face the issue, please reproduce the issue in the sample and send back.
Regards,
Prasanna Kumar N.S.V
By analyzing your code example, missing of $ symbol while using jQuery selectors for getting Grid object to enable the summary in the databound event is the root cause for the issue. So, we suggest you to use the $ symbol or jQuery while using jQuery selector to properly get the Grid object.
Please find the code example, screenshot and sample:
|
<asp:Content runat="server" ID="FeaturedContent" ContentPlaceHolderID="FeaturedContent"> <ej:Grid runat="server" ID="gridDatos" AllowPaging="true" AllowGrouping="true" AllowScrolling="true" AllowFiltering="true" AllowTextWrap="true" AllowResizing="true" AllowResizeToFit="true" OnServerExcelExporting="gridDatos_ServerExcelExporting" DataSourceID="SqlDSResumen"> <ToolbarSettings ShowToolbar="true" ToolbarItems="excelExport"></ToolbarSettings> <GroupSettings GroupedColumns="Area" ShowDropArea="true" /> <FilterSettings FilterType="Excel"></FilterSettings> <ClientSideEvents DataBound="databound" />
</ej:Grid>
---------------------------
<script type="text/javascript">
function databound(args) {
this.model.summaryRows.push({ title: "Sum", summaryColumns: [{ summaryType: ej.Grid.SummaryType.Sum, displayColumn: this.model.columns[2].headerText, dataMember: this.model.columns[2].headerText, format: "{0:C2}", prefix: "Sum =" }] });
$("#" + args.model.clientId).ejGrid("model.showSummary", true);
}
|
Screenshot :
Sample: http://www.syncfusion.com/downloads/support/forum/121522/ze/SampleButton-1483815088
Regards,
Prasanna Kumar N.S.V
For exporting, we have already suggested you to convert the datasource to list of data.
Please find the code example, screenshot and modified sample:
|
protected void gridDatos_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e) { ExcelExport exp = new ExcelExport(); DataView datos = (DataView)SqlDSResumen.Select(DataSourceSelectArguments.Empty); DataTable dt = datos.Table; var emp = (from DataRow row in dt.Rows
select new Order { Area = row["Area"].ToString(), Provincia = row["Provincia"].ToString(), Week10 = Convert.ToInt32(row["Week10"]), Week11 = Convert.ToInt32(row["Week11"]), Week13 = Convert.ToInt32(row["Week13"]), }).ToList(); exp.Export(gridDatos.Model, (IEnumerable)emp, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime"); } } }
public class Order { public string Area { get; set; } public string Provincia { get; set; } public int Week10 { get; set; } public int Week11 { get; set; } public int Week13 { get; set; } |
Screenshot:
Sample: http://www.syncfusion.com/downloads/support/forum/121522/ze/SampleButton_(2)257358207
Regards,
Prasanna Kumar N.S.V
How can I avoid this message if the columns are autogenerated and the datasource is empy?
