<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h2
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:14.0pt;
font-family:Arial;
font-weight:bold;
font-style:italic;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p.PRT2, li.PRT2, div.PRT2
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:6.0pt;
margin-left:36.0pt;
text-align:justify;
text-indent:-18.0pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:Arial;
font-weight:bold;}
span.EmailStyle18
{font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<style>
p.MsoNormal
{margin-left:37.5pt;}
</style>
</head>
<body bgcolor=white background="cid:image001.jpg@01C6ED73.CB1375F0" lang=EN-US
link=blue vlink=purple style='margin-left:37.5pt;margin-top:15.0pt'>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi all,</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Am I missing the plot again. </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>When creating a report on the following objects: </span></font></p>
<p class=MsoNormal style='margin-left:37.5pt;text-indent:34.5pt'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>Quotes, Sales Orders,
Purchase Orders and Invoices </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>there are no ‘Total Amount’ field selection
possibilities. This would be Invoice amount, Sales Order amount etc.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I reconstructed the events and </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> getSecModuleColumnsList($module)</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> calls</span></font></p>
<p class=MsoNormal style='margin-left:37.5pt;text-indent:34.5pt'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>getColumnsListbyBlock($module,$block)
in the \modules\Reports\reports.php class file</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>This produces the following (+-) Sql statement</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><span class=syntaxalphasyntaxalphareservedword><i><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:
italic'>SELECT</span></font></i></span><span class=syntax><i><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:italic'> </span></font></i></span><span
class=syntaxpunct><i><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-style:italic'>*</span></font></i></span><span
class=syntax><i><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-style:italic'> </span></font></i></span><span
class=syntaxalphasyntaxalphareservedword><i><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-style:italic'>FROM</span></font></i></span><span
class=syntax><i><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-style:italic'> </span></font></i></span><span
class=syntaxalphasyntaxalphaidentifier><i><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-style:italic'>vtiger_field</span></font></i></span><i><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:
italic'><br>
<span class=syntaxalphasyntaxalphareservedword>WHERE</span><span class=syntax> </span><span
class=syntaxalphasyntaxalphaidentifier>vtiger_field</span><span
class=syntaxpunctsyntaxpunctqualifier>.</span><span
class=syntaxalphasyntaxalphaidentifier>uitype</span><span class=syntax> </span><span
class=syntaxpunct>!=</span><span class=syntaxdigitsyntaxdigitinteger>50</span><br>
</span></font></i><span class=syntaxalphasyntaxalphareservedword><i><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:
italic'>AND</span></font></i></span><span class=syntax><i><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:italic'> </span></font></i></span><span
class=syntaxquotesyntaxquotebacktick><i><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-style:italic'>`tablename`</span></font></i></span><span
class=syntax><i><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-style:italic'> </span></font></i></span><span
class=syntaxpunct><i><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-style:italic'>=</span></font></i></span><span
class=syntax><i><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-style:italic'> </span></font></i></span><span
class=syntaxquotesyntaxquotesingle><i><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-style:italic'>'vtiger_potential'</span></font></i></span><i><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:
italic'><br>
</span></font></i><span class=syntaxalphasyntaxalphareservedword><i><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:
italic'>AND</span></font></i></span><span class=syntax><i><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:italic'> </span></font></i></span><span
class=syntaxalphasyntaxalphaidentifier><i><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-style:italic'>vtiger_field</span></font></i></span><span
class=syntaxpunctsyntaxpunctqualifier><i><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-style:italic'>.</span></font></i></span><span
class=syntaxalphasyntaxalphaidentifier><i><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-style:italic'>displaytype</span></font></i></span><i><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-style:
italic'><br>
<span class=syntaxalphasyntaxalphareservedword>IN</span><span class=syntax> </span><span
class=syntaxpunctsyntaxpunctbracketopenround>(</span><span class=syntax> </span><span
class=syntaxdigitsyntaxdigitinteger>1</span><span
class=syntaxpunctsyntaxpunctlistsep>,</span><span class=syntax> </span><span
class=syntaxdigitsyntaxdigitinteger>2</span><span class=syntax> </span><span
class=syntaxpunctsyntaxpunctbracketcloseround>)</span><span class=syntax> </span><span
class=syntaxalphasyntaxalphareservedword>ORDER</span><span class=syntax> </span><span
class=syntaxalphasyntaxalphareservedword>BY</span><span class=syntax> </span><span
class=syntaxalphasyntaxalphaidentifier>sequence</span></span></font></i></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I used <span class=syntaxquotesyntaxquotesingle>'vtiger_potential'
as it has a type 71 – money field in it. Trying the same SQL statement on
Invoices etc, there is no sign of the ‘vtiger_invoice.total’ field.</span></span></font></p>
<p class=MsoNormal><span class=syntaxquotesyntaxquotesingle><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></span></p>
<p class=MsoNormal><span class=syntaxquotesyntaxquotesingle><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>So the questions
that arise are:</span></font></span></p>
<p class=MsoNormal><span class=syntaxquotesyntaxquotesingle><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></span></p>
<p class=MsoNormal style='margin-left:90.0pt;text-indent:-18.0pt'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>1)<font size=1
face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><span class=syntaxquotesyntaxquotesingle><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Are there not
supposed to be money fields in </span></font></span><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Quotes, Sales Orders, Purchase
Orders and Invoices by design (would be disappointing)</span></font></p>
<p class=MsoNormal style='margin-left:90.0pt;text-indent:-18.0pt'><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>2)<font size=1
face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></font><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Is this a bug</span></font></p>
<p class=MsoNormal style='margin-left:90.0pt;text-indent:-18.0pt'><span
class=syntaxalphasyntaxalphaidentifier><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>3)<font size=1 face="Times New Roman"><span
style='font:7.0pt "Times New Roman"'> </span></font></span></font></span><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Can I
include an appropriate entry into ‘<span
class=syntaxalphasyntaxalphaidentifier>vtiger_field’ and just see what
happens – follow it from there.</span></span></font></p>
<p class=MsoNormal><span class=syntaxalphasyntaxalphaidentifier><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font></span></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any ideas on this would be much appreciated.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Version: vt 5.0.1 – svn 9621 – XP</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>This vTiger is like a fractal puzzle, the deeper you delve,
the more beautiful it becomes,</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Big thanks to all the team and community – the limits
to this creation are just where you set them.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Regards,</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<div>
<p class=MsoAutoSig><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Ivar </span></font></p>
<p class=MsoAutoSig><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
<p class=MsoAutoSig><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>
</div>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=2>--<BR>
No virus found in this outgoing message.<BR>
Checked by AVG Free Edition.<BR>
Version: 7.1.408 / Virus Database: 268.13.2/471 - Release Date: 2006/10/10<BR>
</FONT> </P>
<P><FONT SIZE=2 FACE="Arial"> </FONT> </P>