Crystal Reports suppressing a data line

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: suppressing a data line

Post Reply

Post New Topic

Author	Message
chris64 Newbie Joined: 19 Mar 2014 Online Status: Offline Posts: 13	Topic: suppressing a data line Posted: 19 Mar 2014 at 4:51am
	Hi, I would like a way of suppressing a data line if two of the formula fields within that line return zeros. Any Suggestions? Thanks, Chris C
	IP Logged


kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 19 Mar 2014 at 4:54am
	You can put a formula for suppressing a group (data line?). If think you would just need a formula something like this: {@formula1} =0 and (@formula2} = 0.
	IP Logged

otto Groupie Joined: 17 Mar 2014 Online Status: Offline Posts: 53	Posted: 19 Mar 2014 at 5:06am
	put this on your section expert/ suppress {@formula1} + (@formula2} = 0
	IP Logged

chris64 Newbie Joined: 19 Mar 2014 Online Status: Offline Posts: 13	Posted: 19 Mar 2014 at 5:17am
	Thanks Kavlray and Otto. That has sorted it. I just needed to find the Section Expert. Regards, Chris
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 19 Mar 2014 at 12:43pm
	FYI: Otto: your solution would work provided both of the formulas returned non-negative number. if {@formula1} returned a -5 and (@formula2} return a 5, then you would have an issue.
	IP Logged

otto Groupie Joined: 17 Mar 2014 Online Status: Offline Posts: 53	Posted: 20 Mar 2014 at 2:55am
	you are right kevlray, that solution is for non-negative values
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum