Crystal Reports Data repeating

Report Design

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

Topic: Data repeating

Author	Message
bturner Newbie Joined: 17 Jun 2010 Location: United States Online Status: Offline Posts: 28	Topic: Data repeating Posted: 19 Aug 2014 at 3:58am
	I have the same file # repeating 20 times on a report when the file # should appear only once. In Select Expert I am using Invoice.SortField equals 1 and property.SortField equals one. In the Section Expert when I check Hide for the details the total is 1 but when I uncheck Hide for details it reveals 20 of the same files.
	IP Logged


z9962 Senior Member Joined: 04 Jul 2012 Online Status: Offline Posts: 161	Posted: 19 Aug 2014 at 5:06am
	Do you have multiple tables in your report, I would suggest looking at your links? or an addtional filter needs to be applied.
	IP Logged

bturner Newbie Joined: 17 Jun 2010 Location: United States Online Status: Offline Posts: 28	Posted: 19 Aug 2014 at 6:00am
	Only one table - looking at links now
	IP Logged

otto Groupie Joined: 17 Mar 2014 Online Status: Offline Posts: 53	Posted: 19 Aug 2014 at 9:08am
	if file# should appears one time only you can make a group by that field.
	IP Logged

bturner Newbie Joined: 17 Jun 2010 Location: United States Online Status: Offline Posts: 28	Posted: 19 Aug 2014 at 9:49am
	My file # is repeating because it's looking at every line item on the invoice so it must be in my formula for the invoice. I only want the total amount of the invoice not every line item from the invoice.
	IP Logged

z9962 Senior Member Joined: 04 Jul 2012 Online Status: Offline Posts: 161	Posted: 19 Aug 2014 at 10:24am
	As otto mentioned, you will need to create a group on file# . Then sum the amount field, place the sum in the group and hide the details section.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 Aug 2014 at 3:23am
	Just to clarify - the formula will not cause repetition of data. Your table joins (or lack there of) "create" that.
	IP Logged

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