computergeek
Programmer
Hello,
How do I group on more than one column and set a selection criteria on the grouped value? For example I would like to implement this SQL group by clause within a Crystal 8.5 report, but it seems you can only set a group on one column? Please tell me this is not the case. I tried changing the SQL statement for the report, but if would not save it?
GROUP BY dbo_v_Transactions_Detail.trans_date, dbo_v_Transactions_Detail.employee, dbo_v_Transactions_Detail.emp_name, dbo_v_Transactions_Detail.project, dbo_v_Transactions_Detail.pjt_entity, dbo_v_Transactions_Detail.Shift, dbo_v_Transactions_Detail.TimeType
HAVING (((Sum(dbo_v_Transactions_Detail.units))<>0));
Thanks! This works fine in MSAccess. : 0 )
Darlene
How do I group on more than one column and set a selection criteria on the grouped value? For example I would like to implement this SQL group by clause within a Crystal 8.5 report, but it seems you can only set a group on one column? Please tell me this is not the case. I tried changing the SQL statement for the report, but if would not save it?
GROUP BY dbo_v_Transactions_Detail.trans_date, dbo_v_Transactions_Detail.employee, dbo_v_Transactions_Detail.emp_name, dbo_v_Transactions_Detail.project, dbo_v_Transactions_Detail.pjt_entity, dbo_v_Transactions_Detail.Shift, dbo_v_Transactions_Detail.TimeType
HAVING (((Sum(dbo_v_Transactions_Detail.units))<>0));
Thanks! This works fine in MSAccess. : 0 )
Darlene