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

[Alan Lord (News)]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot-3.png
Type: image/png
Size: 17629 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20110228/68faae7d/attachment-0002.png