GROUP BY Using RDC

[CrystalVisualBOracle]

Does anyone know why I can't seem to add a "group by" clause to my sql statement before I pass it to my RDC report in VB? Is there some special rules regarding the "group by" clause that I'm unaware of? Does CR not allow it? I'm trying to create a SUMMED ie/ "SUM(fieldA)" SQL Expression field and I think I have to be able to "group by" in order for it to work. But either way, the report keeps erroring saying not a single-group by expression.

Anyone?

Thanks
CrystalVisualBOracle

 

[kenhamady]

I am pretty sure that the SUM function is not supported in the SQL expression editor. All of the supported functions are listed in the Expression editor window. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)