|
-
May 4th, 2006, 06:06 AM
#1
Thread Starter
Member
[RESOLVED] Crystal formula help please
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|