I have the same row in an item description that I only want to appear once

[kdnichols]

Hello All,

How can I get this to appear once and sum on a field?

Let's say the field name is Owner_Desc and the field I want to sum on is Volume. What kind of formula would I need?

Thanks for the help from yesterday's question.

Thanks for reading!

Have a great day!

Kurt

 

[Kempes]

Could you explain a bit more. I don't really understand what you're trying to do.

 

[kdnichols]

I wanted to make this clear.

I have a report that shows:

Tank ID Owner Description Component Name Cat_Type Volume
1 owner a component 1 TR 143.00
1 owner a component 1 TR 142.00
1 owner a component 1 TR 140.00

I want to only show one line item if Tank ID, Owner Descriptoin, Component Name and Cat_Type are the same. I want a count and the line to appear once with a sum of the volume.

I am using Crystal Reports 10 on an Oracle database.

Any help is greatly appreciated!

Kurt

 

[kdnichols]

Showing one line item matching fields in same record

Hello All,

Hopefully this is a better description of what I am trying to do. I want to just show one count in the previous example per record and a sum on the volume. I don't want to keep listing the same product name over and over again.

I really, really need some help and input on this.

Thanks,

Kurt

 

[kdnichols]

I am showing some more detail here:

Tank ID Owner Description Component Name Cat_Type Volume
123 owner a component 1 TR 143.00
123 owner a component 1 TR 142.00
123 owner a component 1 TR 140.00
I want to only show one line item if Tank ID, Owner Descriptoin, Component Name and Cat_Type are the same. I want a count and the line to appear once with a sum of the volume.

So I want to show the following:
Tank ID Owner Description Component Name Cat_Type Voume
123 owner a component 1 TR 385.


In other words, I want to eliminate all of the redundant data and show one line item where there are duplicates and get the volume total.
How do I go about this?
I really, really need some expert help on this.
Again thanks,
Kurt

 

[Kempes]

OK, right click on the figure you want to sum on (volume) within your details section, choose insert summary.
Now choose Sum from the drop down this, and Insert group. Group at the lowest level.
This will put a group on your report.
Drag the value from group footer to group header so it's on 1 line.
Suppress the group footer (right click and suppress), and hide the details section.
This should grey out with the option to drill down if required.
Now all you need to do is drop the remaining text fields into your group header, and you're done.

Alternatively, take a look at the cross tab expert in in the insert menu. This puts it in a grid format.