Hi Alan,<br><br>i think one reason may be "%" in the label, change the label in db to just "Deal Probability" and in translation file add the "%". i think this will solve your problem.<br><br>
Regards,<br>MAK<br><br><div class="gmail_quote">On Mon, Feb 28, 2011 at 9:38 PM, Alan Lord (News) <span dir="ltr"><<a href="mailto:alanslists@gmail.com">alanslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi all,<br>
<br>
I've just upgraded a customer's vtiger system from 5.1.0 to 5.2.1 and it seems to have gone fine on the whole. Thanks.<br>
<br>
But I just got a mail from them.<br>
<br>
He has a custom report pulling in Potentials and Contacts. With the group by configured as shown in the attached screenshot the report does not run and instead prints:<br>
<br>
"<br>
Report generation failed!<br>
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%) DESC' at line 1<br>
"<br>
<br>
If I remove the second group clause (The Deal Probability - Descending) then the report runs fine.<br>
<br>
Suggestions and fixes most welcome :-)<br>
<br>
Cheers<br>
<br>
Al<br><font color="#888888">
<br>
-- <br>
The Open Learning Centre<br>
<a href="http://www.theopenlearningcentre.com" target="_blank">http://www.theopenlearningcentre.com</a><br>
</font><br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br>