Solved

Summing and eliminate duplicates in crystal report 8.5

Posted on 2009-04-10
10
1,019 Views
Last Modified: 2012-05-06
Dear Experts,

I have a database table that store saledetails from an invoicing program. In that table I have the following fields:
- saleid
- item_code
- item_name
- quantity
- supplier_code
- customer_code

What I'm trying to do is to print a record which will show the amount of item a specific customer has ordered. (ie. customer A has made many purchases and he had ordered item A 3 times with quantity 5 each times, item B 2 times with quantity 3 each time and item C 1 time with quantity 1.)

I want my report to show

item_code      quantity
A                      15
B                       6
C                       1

so far, whenever i execute the crystal report, it will print the following:

item_code       quantity
A                         5
A                         5
A                         5
B                         3
B                         3
C                         1

I've used a group by item_code and subtotal field. With subtotal i can get the total quantity for each item, but the report still showed a particular item multiple times and the subtotal fields also showed in the group footer section, which made my report looks messy. Any idea how do i get the report i want experts? Thank you.
0
Comment
Question by:Slythie
  • 6
  • 3
10 Comments
 
LVL 17

Accepted Solution

by:
MIKE earned 80 total points
ID: 24116836
Right click in the GRAY area out to the right of the DETAILS Section that you don't want to see...and choose SUPPRESS.

Incidentally all sections can be adjusted this way.....
0
 
LVL 17

Expert Comment

by:MIKE
ID: 24116842
SORRY right click in the GRAY area out to the ***LEFT*** ...not the right....
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 45 total points
ID: 24116890
That will suppress the detail section

To get the totals
Group by the item code
Right click the QTY field
Click INSERT --> SUMMARY
Set summary as sum
Set location as the group footer
Drag the field in the footer to the group header
Suppress the group footer

mlmcc
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 17

Expert Comment

by:MIKE
ID: 24116980
Slythie:

According to your last comments,...it looks like you already have your Subtotal setup the way you want it, and so now you only need to SUPRESS the display of the DETAILS section in order to fix your issue.

At this point,...it appears to be a Formatting Display issue....of course you may need to do some other formatting, but that should be cosmetics only...

Hope it helps
0
 

Author Comment

by:Slythie
ID: 24117143
thx for the response experts. I've tried all you've suggested but i can't get rid of the multiple entries for each items.

My reports still show:

item_code       quantity
A                         5
A                         5
A                         5
                           15 (subtotal)
B                         3
B                         3
                           6 (subtotal)
C                         1
                           1 (subtotal)

i want my report to print each item once with the subtotal on the same line as the item_code. Is there anyway to do it? thx
0
 
LVL 17

Expert Comment

by:MIKE
ID: 24117184
What SECTION are these lines showing up in:

A                         5
A                         5
A                         5

Look out to the LEFT of those lines in the report design tab...in the gray area...what is shown there..
0
 

Author Comment

by:Slythie
ID: 24117189
ohh ok nvm experts... i got what u guys are trying to say now... silly me, its just about playing with the group headers eh?? hehehe.. thx a bunch experts.. =)
0
 
LVL 17

Expert Comment

by:MIKE
ID: 24117190
Just RIGHT CLICK whatever section is there...and SUPPRESS it....
0
 
LVL 17

Expert Comment

by:MIKE
ID: 24117200
You may need to copy/paste the ITEM_CODE into the Group Footer to display it for your report...
0
 

Author Closing Comment

by:Slythie
ID: 31568951
Thank you everyone.. =)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Report Error 14 84
Crystal Reports with Yardi error 800a004b 2 118
Crystal Reports Server, Unable to remove users 8 41
Cyrstal Reports formula to check IsNull 8 30
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now