We help IT Professionals succeed at work.

How to supress a single detail row based on a value.

townsma
townsma asked
on
473 Views
Last Modified: 2012-02-09
I have a standard list type report, that contains a single standard detail section.  One of these fields in the detail section is a price value.  What I want to do is exclude any rows where the price is 0. All other rows should print normally, with no space where the missing row was.

I am sure I have done this before, but cannot remember how I did it.  Can someone please refresh my memory.

Thanks
Comment
Watch Question

CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Does the supress in the section expert suppress rows or entire sections? I had it in my mind it supresses entire sections.

Commented:
If you just select suppress then it would suppress all detail rows, that is why as mlmcc reccomends you should use a conditional suppression formula that only suppresses details that meet the suppression rules.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
The section expert applies to the full section.  The detail section is used for each record.  Each detail section for a record is considered to be a full detail section for the section expert functions.

mlmcc
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.