Suppressing Group Header based on total of the group

[dreman]

Using CR 8.5:
Report ig group by salesman + Customer:
Group#1: (salesman)
Group#2H: Cust# (name)
detail#1a: (suppressed)cust, invoicedate , sales$), profit$
Group#2F: count(cust), RT(sales$), RT(profit$)

What I would like is to suppress Group#2H for any condition where invoicedate>{?user date}
How do I suppress Group#2H, I am able to suppress Group#2F based on RTcount(cust) Running Total, but do not know how to suppress Group#2H when RTcount(cust)=<0.
Please advice.
Thank you.
dré

 

[chelseatech]

Running Totals are calculted too late to be used to suppress the group header.

But Summaries are not. Can you use
Sum(Sales$,Cust#)

Or might Minimum(InvoiceDate,Cust#) give you the earliest invoice date. Maximum gives you the last invoice date for that customer. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[dreman]

Ctech:
I need to use RunningTotal since suppressing some information is based on a formula.
However isn't there a function to calculate 2nd pass.
I do not how to use it.
Min and Max will not do, but will try it anyways.
Thank you.
dré

 

[kenhamady]

In many cases you can create a summary that only includes records that meet a criteria without using running totals. Depends on the criteria formula. Can you post the evaluate formula from your running total? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[dreman]

Ken:
Thanks for the reply.
As for the running total formula:
//
{@F_Net_Stock} =< {table.inv_min) and {table.inv_max}<>0
// @Net_stock = table.qoh - table.alloc - table.bo

How can I get summary using this formula (I am using Running Total)

detail section suppressed based on this formula:
{@Net_Stock} > {table.inv_min} and {table.inv_max}<>0
Thanks.
dré

 

[dreman]

Ken:
Your reply gave me an idea of setting another boolean formula based on the criteria itself set to Y or N.
It works.
I summarize this boolean criteria to get Maximum. Since summarizing are carried to Group Headrs. So, by getting Yes or No I suppress Group header.
Thanks for the info and help.
dré