Print Page | Close Window

Remove duplicates AND empty rows Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19040 Printed Date: 04 May 2024 at 7:24am Topic: Remove duplicates AND empty rows Posted By: Nigge Subject: Remove duplicates AND empty rows Date 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? Replies: Posted By: Sastry Date 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 Posted By: bal1 Date Posted: 06 Feb 2013 at 5:17am Enter your field in Select Expert Formula not (IsNull({Field} ))

Print Page | Close Window