Though it is not in the list, you can still type it as "SUM(nAmt) AS nSum" in the desinger and it won't give you any error.

>I have a table with all sales detail for the past 3 years (more than 250,000 records) and I'm moving it to SQL server But When i try to create a view to query lets say total sales by Partnumber I would do it like this localy
>
>
> select part,sum(qty) from sales group by part
>
>
>but in the view builder for remote views the function sum() is not there.
>
>How do you do it?