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
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