[RESOLVED] Crystal formula help please

[RayComp]

Thanks to all who helped me in the past

I use a formula field to print a message only when items are all packed into one carton

if {Despatch.Type} = "OverPack" then

if {Despatch.caseno} = "" then
""
else "All packed in carton #" & {Despatch.caseno} & Sum({Despatch.weight}) & " kg"


Should print the weight for items inside a particular carton after the contents list for each carton only if packed together.


All Packed in carton #1 7 kg

All Packed in carton #2 4 kg

All Packed in carton #3 3 kg

I have placed the formula in the group Footer (grouped by despatch.caseno)
but it still prints the total weight of all items against each carton like

All Packed in carton #1 14 kg

All Packed in carton #2 14 kg

All Packed in carton #3 14 kg

When Items are sent unpacked then the weight gets printed next to the items like
2 x Monitors 6 kg
3 xPrintwers 2.5kg
This works OK

Alternatively i can use formula field

if {Despatch.Type} = "OverPack" then

if {Despatch.caseno} = "" then
""
else "All packed in carton #" & {Despatch.caseno}

AND insert a summary field in the group footer But need then to suppress the summary field if not packed together

Either way I need some help please
PS. How do I flag a message when resolved?

[bmahler]

did you try running a Running Total field on the package weights?
you can create one and have it sum the weights and reset on group change.

hopefully this helps.

p.s. to mark as resolved, click thread tools at the top of your thread and the mark as resolved option should appear in the drop down.