Suppress Group by Condition

Anmi picture Anmi · Jan 17, 2014 · Viewed 11.5k times · Source

I've a crystal report like this:

Page Header
       2013 & 2014 Salesman Performance Report

Group Header
       Salesman: {Salesman}
       Month     2013         2014
Details
       {Month}   {2013Amt}    {2014Amt}
Group Footer
       Total:    {#2013}      {#2014}

Result:

2013 & 2014 Salesman Performance Report

Salesman: Billy
        2013        2014
Jan     1,000.00    0.00
Feb     500.00      800.00
Total   1,500.00    800.00

Salesman: Keith
        2013        2014
Jan     0.00        0.00
Feb     0.00        0.00
Total   0.00        0.00

Salesman: Candy
        2013        2014
Jan     (200.00)    0.00
Feb     0.00        200.00
Total   (200.00)    200.00

Is it possible to suppress the salesman group "Keith" if there're no transaction on 2013 & 2014?


Thank you for the suggestions from craig & Siva. There's a problem, if the total sum for a salesman is 0 but there're transactions. How to handle it?
For example:

Salesman: Kitty
        2013        2014
Jan     (200.00)    0.00
Feb     200.00      0.00
Total   0.00        0.00

I can have the finally result now although I'm not sure the method is correct or not.
Create formula field Count1 & Count2 and input the following formula

Count1: If {2013Amt} <> 0.00 then 1 else 0
Count2: If {2014Amt} <> 0.00 then 1 else 0


Then input the following formula into Group header, details and group footer (section expert> Suppress)

Sum({@Count1},{Salesman})=0 and Sum({@Count2},{Salesman})=0

Answer

craig picture craig · Jan 17, 2014

You will be able to do so, but not with a running total field--running total fields can only be used in the footer.

Instead, add the following conditional-suppressional formula to the salesman header, salesman footer, and details sections:

Sum({2013Amt},{Salesman})=0 And Sum({2014Amt},{Salesman})=0