Hello,
We are now working to create advanced reporting utilizing K2's Report Builder and modifying RDL in Visual Studio for republish. In both the Report Builder and VS, I am unable to perform the "Group By' clause within my smartobject query. In theory, the SmartObject should query just like SQL, right?
Is this functionality missing from Smart Objects and if so, what options exist to perform data specific aggregate functions like SUM and AVG? Please note that I am not talking about simple AVG and SUM functions where all of the data is combined into a final average or sum, but am instead referring to the ability to group mulitple like columns and get the breakdown by like columns.