[Vtigercrm-developers] Reports giving SQL Error with cascaded Grouping

[Musavir Khan]

Hi Alan,

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.

Regards,
MAK

On Mon, Feb 28, 2011 at 9:38 PM, Alan Lord (News) <alanslists at gmail.com>wrote:

> Hi all,
>
> 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.
>
> But I just got a mail from them.
>
> 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:
>
> "
> Report generation failed!
> 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
> "
>
> If I remove the second group clause (The Deal Probability - Descending)
> then the report runs fine.
>
> Suggestions and fixes most welcome :-)
>
> Cheers
>
> Al
>
> --
> The Open Learning Centre
> http://www.theopenlearningcentre.com
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20110301/e42d3141/attachment-0002.html