I am grouping data but only want to choose the dataset if the grouped total of an amount field is > zero. I believe I can do it with ReportBuilder by not displaying the grouped line from within calculations tab, but then I have to also manually total fields and so on, it is far easier (and faster processing time) if HAVING can be used.
Not to worry I will use the approach I have mentioned.
Comments
Sorry, but there is currently no support for the Having clause.
You would have to manually edit the SQL.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Let me know more about what you are trying to accomplish - perhaps there is
some other approach.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
I am grouping data but only want to choose the dataset if the grouped total
of an amount field is > zero. I believe I can do it with ReportBuilder by
not displaying the grouped line from within calculations tab, but then I
have to also manually total fields and so on, it is far easier (and faster
processing time) if HAVING can be used.
Not to worry I will use the approach I have mentioned.
Regards
Alex