Crystal Reports Remove duplicates AND empty rows

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

Topic: Remove duplicates AND empty rows

Author	Message
Nigge Newbie Joined: 03 Feb 2013 Online Status: Offline Posts: 6	Topic: Remove duplicates AND empty rows Posted: 05 Feb 2013 at 9:30pm
	Hi! I have read a different threads regarding removing duplicates. I have checked supress if duplicates (or what the checkbox is called...) That removes the duplicates but instead there is empty rows. Is it possible to remove these empty rows?
	IP Logged

Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 06 Feb 2013 at 3:59am
	HI Go in Section Expert and select the section where you have duplicate records (detail mostly) then select Suppress Formula editor and give the following condition. Example : if {field} = previous({Field}) then true else false
	Thanks, Sastry
	IP Logged

bal1 Groupie Joined: 28 Nov 2012 Online Status: Offline Posts: 44	Posted: 06 Feb 2013 at 5:17am
	Enter your field in Select Expert Formula not (IsNull({Field} ))
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.031 seconds.