Hi,

I have a dataset with one datatable with 2 columns, 'R_ID' and 'Miles'.

I want to create a dataview based on the datatable.

The SQL for the view I want is:

SELECT R_ID
  FROM datatable
 GROUP BY R_ID
HAVING count > 1

can this be done or can dataviews only be created with trivial criteria? and if so is there anyway I can do this? (I can't run this query against the data provider).

Cheers,

A.