<p><!--p session_start();--><!--CTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dt-->
<script type="text/javascript"></script>
<!--CTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//E--></p>
<p class="western" style="margin-bottom: 0cm" lang="pt-BR"><span style="color: #000000;"><span style="font-size: small;"><em><strong>C22 - Simple Consultation using GroupBy and Sum <a href="http://www.scriptcase.info/site/support/examples/videos/" target="_fora"></a><span class="style2"><span class="style3"><strong></strong></span></span></strong></em></span></span></p>
<p class="western" style="margin-bottom: 0cm" lang="pt-BR"><span lang="pt-BR"><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"><span style="color: #000000;"><strong><span lang="pt-BR" xml:lang="pt-BR"><span style="color: #000000;"><strong>Application Name</strong></span></span></strong><strong>:</strong> cons_b_sum<br /><strong>Base Table:</strong> customers<br /><strong>Description:</strong> Customers Consultation with GroupBy per Region and Sum per CreditLimit.<br /><span style="font-size: xx-small;"><strong><span lang="pt-BR" xml:lang="pt-BR"><span style="font-family: Verdana, sans-serif;"><span style="color: #000000;"><strong>Field that will be displayed:</strong></span></span></span></strong> </span>CustomerID,CompanyName,Address,City and CreditLimit.<br /><strong>GroupBy Fields</strong>: Region<br /><strong>Message in the Summary Line</strong>: Region Total {Region}<br /><strong>Summary Fields:</strong> CreditLimit<br /></span></span></span></span><span style="font-size: x-small;"><span style="font-size: x-small;"><span style="font-size: xx-small;"><span style="font-family: Verdana,Arial,Helvetica,sans-serif;"><strong>Orientation</strong></span></span><span style="font-family: Verdana,sans-serif;"><strong>:</strong> Horizontal<br /><span style="font-size: xx-small;"><strong>Pagination:</strong> </span>Partial<br /></span><span style="font-size: x-small;"><span style="font-family: Verdana,Arial,Helvetica,sans-serif;"><span style="font-size: xx-small;"><strong>Lines per Page</strong>:</span> 10</span></span></span><span style="font-family: Verdana,sans-serif;"><br /><span lang="pt-BR"><span style="color: #000000;"><strong>Table width:</strong> 60<br /><span lang="pt-BR"><span style="font-size: x-small;"><span style="font-family: Verdana, sans-serif;"><span style="color: #000000;"><font size="1"><strong>Table width </strong></font><font size="1"><font face="Verdana, sans-serif"><span lang="pt-BR"><font face="Verdana, sans-serif"><span lang="pt-BR"><font face="Verdana, sans-serif"><span lang="pt-BR"><font color="#000000"><font face="Verdana, sans-serif"><span lang="pt-BR"><strong>unit</strong></span></font></font></span></font></span></font></span></font>:</font> Percent</span></span></span></span><br /><span style="font-size: xx-small;"><span lang="pt-BR" xml:lang="pt-BR"><span style="font-family: Verdana, sans-serif;"><span style="color: #000000;"><strong>Header-&gt; Consultation Title</strong>:</span></span></span></span> Customers Consultation with GroupBy per Region and Sum per CreditLimit.</span></span></span></span></p>