cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Line Results

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.