Suppress Group by Condition
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
Anmi
Updated on June 29, 2022Comments
-
Anmi almost 2 years
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 formulaCount1: 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
-
Anmi over 10 yearsThanks for your suggestion, I've updated my question. If there're transactions but the total sum is 0. I didn't know how to handle it.
-
Anmi over 10 yearsThanks for your suggestion, I've updated my question. If there're transactions but the total sum is 0. I didn't know how to handle it.