having after group by

rbuser

Hi All.

Is there any chance to use having in reportbuilder?
Simething like that

Select field1,sum(filed2)
from table
group by filed1
having sum(filed2)<>0

Vladimir
__________________________________________________________________ Vladimir
Chumak ICQ#: 131525783 Current ICQ status: + More ways to contact me
__________________________________________________________________

nicocizik

Hi Vladimir,

The ReportBuilder Query Designer does not support the "having" clause. If
you would like to use it, you will have to edit the SQL manually. Remember
that once you edit the SQL manually, you will loose the functionality of the
Query Designer and linking capabilities. If it is absolutely necessary to
use the 'having' clause, you can manually link queries by code. The
following example shows how to do this.

http://www.digital-metaphors.com/tips/LinkEditSQLDataviews.zip

--