How is every do their aggregates, especially COUNT?

I don't really want to use SPs, whats the best solution until Frans get round to adding these functions.

Cheers

With a proc, I'm afraid. (I know, not ideal...).

I had a good play with this last night and loaded the TypedList or View into a DataTable and then using the compute method carried out my aggregates that way.

Do you think a proc would be more efficient?

The typed view and typed list classes are already datatables, so you can just create a dataview using these.

If the typed view/typed list objects contain lots of data, it's not that efficient of course, but a few rows don't hurt much.

Like this -

 surveyStats.DataSet.Tables[0].Compute("COUNT(Surhowmany)","").ToString();

I'll have to run some tests, but if a stored procedure is the way forward for now then so be it. The view will hold 500 to 5000 records, so really not to many, but there are a lot of stats to come off.