Getting a sql statement using Having

rbuser

Hello,

I tried to get a sql statement like this using the end-user tool:

select count(*), registrationnumber
from rei_client
group by registrationnumber
having count(*) > 1

I can't find the way to get the "Having" clause in it.
Can this be done??

Eric

nicocizik

Hi Eric,

Sorry, unfortunately the use of the "Having" clause in the data workspace is
not supported.

--
Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
Delphi Informant Readers Choice awards!

http://www.delphizine.com/ballot2004/

rbuser

Will it be in the future??

Eric

nicocizik

Hi Eric,

It is definitely on our list of possible future enhancements for
ReportBuilder.

--
Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
Delphi Informant Readers Choice awards!

http://www.delphizine.com/ballot2004/

rbuser

Thats fast response!