</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">FlexReport for WinForms </div> <div id="PageTitle"><div id="PageTitleText">Calculated Field</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="WorkingwithFlexReportDesigner.html">Working with FlexReportDesigner </a> > <a href="AddingFlexReportFields.html">Adding FlexReport Fields</a> > Calculated Field</td></tr></table></div> <div id="BodyContent"> <p>In order to create fields that do not use raw data, <strong>Calculated</strong> fields are the best option. Calculated fields contain expressions that are evaluated at run-time. They are used to generate those data values that are not stored in the data base.</p> <p>Some predefined expressions are available in the dropdown of Calculated Fields.</p> <p>To add a predefined Calculated field using FlexReportDesigner application:</p> <ol> <li>Create a new FlexReport in C1FlexReportDesigner.</li> <li>From <strong>Insert</strong> tab, add two <strong>Calculated</strong> fields - 'Date Created' and 'Page n of m', in the PageFooter section:<br> <br> <img border="0" alt="" src="ImagesExt/InsertCalculatedField_Option.png"></li> <li>Note the expressions in these calculated fields in the design area.<br> <br> <img border="0" alt="" src="ImagesExt/InsertCalculatedField.png"></li> <li>Preview the report.<br> <br> <img border="0" alt="" src="ImagesExt/CalculatedFieldPreview.png"></li> </ol> <p>To define a Calculated field and add the field in the FlexReportDesigner application:</p> <ol> <li>Create a new report. </li> <li>Bind the report with '<strong>Orders Details</strong>' Table. </li> <li>In Group Header, add a <strong>Text</strong> field 'Total' to display label for the total price.</li> <li>Go to <strong>Data</strong> tab, and right-click the Main data source and select <strong>Add Calculated Field</strong>. VBScript Editor appears.</li> <li>In the <strong>VBScript Editor</strong>, write the following expression: <p><code>Quantity*UnitPrice</code></p> </li> <li> <p>Drop the above mentioned Calculated field as shown.</p><img border="0" alt="" src="ImagesExt/InsertCalculatedField_TotalPrice.png"> </li> <li>Preview the report.<br> <br> <img border="0" alt="" src="ImagesExt/CalculatedFieldPreview_TotalPrice.png"></li> </ol> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright © <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a href="http://our.componentone.com/groups/" target="_blank">Product Support Forum</a> | <a href="http://feedback.componentone.com/forums/255782-winforms-documentation" target="_blank">Documentation Feedback</a> </div> </body> </html>