Crystal Reports XI query syntax for Progress

[fizz]

I need to pull Grouped, Summed data from a Progress DB but the only access I have is via Crystal. The DB is locked within an application that is managed by the providers.

I need to use the Crystal Command function to create a "view" that can be linked to tables within the DB but receive "Column not Found" errors when using a standard syntax: eg

SELECT Sum(DB.fieldname1) as SumField, DB.fieldname2
FROM DB
GROUP BY fieldname2

Assume all the double quotes are in place as required.

Any ideas/suggestions??

Thanks

 

[BONO]

Hello,
Here syntax of a sql command on crystal report with parameter:
u've to use alias to don't prefix tables. Be carefull with array field also

SELECT xvlpba.clicodliv, xvlpba.etsnumliv, SUM(xvlpba.lipvalfac * xvlpba.facavo), SUM(xvlpba.lipvaldpr * xvlpba.facavo)
FROM pub.xvlpba XVLPBA
where xvlpba.stecod = '{?Société}'
and xvlpba.facdat >= {?DateDeb}
and xvlpba.facdat <= {?DateFin}
GROUP BY xvlpba.clicodliv, xvlpba.etsnumliv