on 08-26-2009 6:33 PM
I use Crystal to get shipments by warehouse.
The only way to get this is by Order Entry line item detail - Warehouse # field. However, if I group by
invoice #, I get multiple line results for every line item on the invoice. I only need one.
So if I have total fields in the detail, I get repeated info.
I cannot surpress becuause some totls may be the same on multiple invoices.
If the last item on the invoice is freight or misc. charge, there is no warehouse associated with this so i get no answer if I just take the last record.
The item line field (status) DOES NOT WORK other wise I could use a formula to pick warehouse for item # 1 line.
Does anyone have any ideas?
If you could post some sample data that would help.
What about multiple groups. group by warehouse and then date, item number etc.
Once you have these, supress the group headers / footers as needed.. Again a sample of the
data would help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.