calc sum when suppress if duplicated?

[Hakana]

Hi.
My problem is this:
I inserted a subreport that presents all the materials that is connected to a detail for production.
I want to present how much material that is needed / material.
The materials can be of different kinds and i dont want duplicates.
When i say "suppress if duplicated i get the graphical result i want but....
I want to keep track of the total amount of material and this number needs to be calculated.
How can i keep adding the material i suppress?

/Hakan

 

[lbass]

Suppressed values contribute to inserted summaries or calculations, so you should be able to insert summaries or use formulas for calculations in the usual way.

-LB

 

[Hakana]

Ohh missed that one.
Searched a little and found many answers.

Though i havnt figured this one out:
I have a row of materialnumber. on the same row there is a calculation of how much material times the amount of details.
If i suppress a duplicated materialnumber, how can i sum this amount on the row that did not get suppressed?

And how do i know when to suppress the sum on the row that gets suppressed because of materialnr

Or am i doing this all wrong?

EX:
Artnr: Sumkvant*number)
55555 2,3
55411 1,25
0,25 (suppressed the artnr cause its 55555 but i dont know how to suppress the sum. And if i suppress the sum it does not gets added to the other position)

Thankfull for help.

/Hakana

 

[lbass]

It sounds like what you need to do is insert a group on {table.artnr}. Then right click on the formula that multiplies kvant times some number and insert a sum on the formula at the artnr group level. Drag the result into the group header and then suppress the detail section.

-LB

 

[Hakana]

I will try this.

I want to thank you all for responding so fast.

You are the greatest to take your time on me.

If i dont respond before new year i wish you Ibass and all on this forum the best new year ever.

/Hakana

 

[Hakana]

Thank for tip cause it was exactly what i needed to do.


/Hakana