Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

HAVING-SQL Statement

edited August 2008 in DADE
Hi list,

this question has already been asked on the 25th of October last year
(2007) by Branden Johnson. The answer that time was:


and


Did you include that feature meanwhile or is it still necessary to
manually edit the SQL?

I need to check if a SUM()-column is 0 or not in the query.
I can add the column in the search-view, but the ReportBuilder creates a
where clause out of that which does not work (obviously).

Regards,
Christoph



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • edited August 2008
    Hi Christoph,

    There is still currently no having clause support in DADE however we are
    very strongly considering adding this feature for the next major release of
    ReportBuilder. For time being, you would still need to edit the SQL code
    manually.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2008
    >Did you include that feature meanwhile or is it still necessary to

    Well, what I need to accomplish is that I have to skip those entries which
    are zero inside a group.
    I have a group containing 6 entries of which 4 are 0, so I need to skip
    them. I can accomplish this by just setting all items in the detail band
    to "visible := false" and the height of the detail band to dynamic.
    That works as long as I have at least one entry which is non-zero.

    But if I only have entries in which my check-column equals zero, I get a
    page with only the group header and footer, which is unwanted.

    Any help is appreciated.

    Regards,
    Christoph



    --- posted by geoForum on http://delphi.newswhat.com
  • edited August 2008
    Hi Nico,

    thanks for the quick response.


    The problem with the manual editing is that we're using the "search
    dialogue" option to pass a value to the report which doesn't work any more
    after manually editing the report.

    I didn't see your post some minutes ago and I have already posted a reply
    to my first post which describes my general problem.

    It would be nice if you could read that entry and help me with my problem.

    Regards,
    Christoph



    --- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.