Crystal Reports Remove Duplicate lines in crystal reports

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Remove Duplicate lines in crystal reports
	<< Prev Page of 3

Author	Message
tmp_man Newbie Joined: 12 Mar 2012 Location: United States Online Status: Offline Posts: 6	Posted: 12 Mar 2012 at 9:57am
	nope it does not work for me.... I end up using the formula from the previous page which is the same formula that you gave me and that is how I end up with the invoice or the 3rd column in my report... even after refresh all the duplicates are still there.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Mar 2012 at 10:15am
	maybe it is not null and just an empty string try your select expert to exclude rows use not (trim(*table.ordernumber)="") or in the suppression option use trim(table.ordernumber*)=""
	IP Logged

tmp_man Newbie Joined: 12 Mar 2012 Location: United States Online Status: Offline Posts: 6	Posted: 12 Mar 2012 at 10:30am
	all sorted now thanks for all the help... this forum is amazing...
	IP Logged

Motib Newbie Joined: 06 Feb 2013 Location: Pakistan Online Status: Offline Posts: 5	Posted: 30 Mar 2013 at 12:09am
	Hi Guy's, I am using CR2008. i have many duplicate values in my report. i remove that values with using the "Suppress if duplicate" from the formatting of the field. but when i create Running total of that field it showing me Suppress values also..... Is any one here who help me...... Thanks in advance.......
	IP Logged

pachorkar Newbie Joined: 23 Apr 2014 Online Status: Offline Posts: 1	Posted: 23 Apr 2014 at 6:49pm
	Thanks a lot Sarah. This helped me very much.
	IP Logged

brreid Newbie Joined: 19 Mar 2007 Online Status: Offline Posts: 11	Posted: 15 Dec 2015 at 5:56am
	Sarah, thank you very much for this formula, it save me hours of work. you rock!! Brenda
	Thanks for sharing the knowledge
	IP Logged

<< Prev Page of 3

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.