×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Hide group section based on totals

Hide group section based on totals

Hide group section based on totals

(OP)
Hi

I have a group section containing a content frame and an after frame. In the after frame I show the total of the column "Qty".
I would like to hide the group section if the total qty is 0.

Thank you

RE: Hide group section based on totals

If you don't have the sum of that column as a column on that row, you can use the adjust size of the after frame to check and see in that sum is 0.  If it is then you can set the height of the frame to 0

RE: Hide group section based on totals

(OP)
I want to hide everything inside the group, the content frame also.
I know the value of the total only when the after frame was generated. The content frames (the detail) are generated before the after frame. So I can not know if I have to hide them or not, because the total was not yet calculated.

RE: Hide group section based on totals

hope about using a lookahead aggregate like
SUM (qty) where (blah) group by (blah)?

OR add that sum in your SQL and make it a cloulm on your sql so that you can test it in the content frame as well?

RE: Hide group section based on totals

(OP)
If I set the height of the frame to 0, the pages contain empty spaces where the frames should have been. Is there a way to avoid this ?

RE: Hide group section based on totals

It does?  Are these frames at the end of the page and then there is a page break after perhaps so you get all the blank space after?

RE: Hide group section based on totals

How about;
set up a variable Static MostRecentFlow As AcFlow in the finish method of the group.  Then Set MostRecentFlow = flow . Then test for the value of your total.  If 0, set the size.height of your flow to 0.
ASG

RE: Hide group section based on totals

From the last post.  On second thoughts, that may leave you with a blank page.  If so try Static MostRecentContainer As AcReportComponent, then do the same.
ASG

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close