DataSetHelper SelectGroupByInto

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to modify the DataSetHelper method InsertGroupByInto to include
two fields in the group by clause, for instance I add EmployeeDept as a
column and try to group by EmployeeID, EmployeeDept. Code is giving errors.

dsHelper.InsertGroupByInto(ds.Tables!OrderSummary, ds.Tables!Orders,
"EmployeeID, EmployeeDept, count(Amount) Orders,sum(Amount)
OrderTotal,max(Amount) BestOrder,min(Amount) WorstOrder", "", "EmployeeID,
EmployeeDept")

What needs to be changed in the helper class to allow the group by of more
than one field?
 
Back
Top