Having?

rbuser

Is there any way to add a having statement?

rbuser

I just created a calculated field to get the difference between the two
fields and added the calculated filed to the search tab as calculated Field

I would still like to know if there is any way to add a having statement
through!!!

Thanks All,
Branden Johnson

rbuser

No, actually I jumped the gun on the previous post, I am still not able to
do this!!!

I have a field being summed from another table and I need to get a result
set containing all records in which a field in the main result set table is
greater than the sum of the a field in the other table.

nicocizik

Hi Branden,

Sorry, but there is currently no support for the Having clause in
ReportBuilder.

You would have to manually edit the SQL.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

As far as I know many "having" can be subsitute with subqueries....
This is the theory .... maybe some help!
;-)