﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?)  » Can assign to XtraReport dynamic data to calculate the total ?</title><generator>InstantForum 2017-1 Final</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>StrataFrame Forum</webMaster><lastBuildDate>Tue, 09 Jun 2026 05:47:23 GMT</lastBuildDate><ttl>20</ttl><item><title>Can assign to XtraReport dynamic data to calculate the total ?</title><link>http://forum.strataframe.net/FindPost33281.aspx</link><description>&lt;div&gt;Suppose I have the following code:&lt;br/&gt;&lt;br/&gt;&lt;div&gt;[CODE]&lt;div&gt;private void button1_Click(object sender, EventArgs e)&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; DataTable dt = CreateTableBill(10);&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; rptReport rpt = new rptReport();&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; rpt.DataSource = dt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; rpt.ShowPreview();&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;br/&gt;&lt;br/&gt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; private static DataTable CreateTable(int RowCount)&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; DataTable tbl = new DataTable();&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; tbl.Columns.Add("ID", typeof(int));&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; tbl.Columns.Add("Product", typeof(string)); &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; tbl.Columns.Add("Number", typeof(int));&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; tbl.Columns.Add("UnitPrice", typeof(int)); &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; for (int i = 0; i &amp;lt; RowCount; i++)&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; tbl.Rows.Add(new object[] { i + 1, String.Format("Product {0}", i), 3 - i, 2.5 * 100 });&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; return tbl;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;div&gt;[/CODE]&lt;br/&gt;&lt;br/&gt;&lt;div&gt;to turn on their schools dt can be assigned to schools dt&lt;div&gt;XrTableCell1 = [Product];&lt;div&gt;XrTableCell2 = [Number];&lt;div&gt;XrTableCell3 = [UnitPrice];&lt;div&gt;XrTableCell4 = [Number] * [UnitPrice];&lt;div&gt;XrTableCell5 += Sum ([Number] * [UnitPrice]);&lt;br/&gt;&lt;br/&gt;&lt;div&gt;when you open the report in design mode, I want to calculate the sum of XrTableCell5, I have to XrTableCell5 under DataBindings-&amp;gt; Text: assignment: Sum ([Number] * [UnitPrice]), but the result None, why not calculate the total be ? you see attach file [url]http://www.mediafire.com/view/s1fs5fhxnz4z1f2/Sumbill.jpg[/url]</description><pubDate>Mon, 15 Feb 2016 01:44:52 GMT</pubDate><dc:creator>Dong Trien Lam</dc:creator></item></channel></rss>