I have set up a simple report to list the unconfirmed pick tickets as a checklist for the warehouse.The database field is pick_ticket_no. I just want to see this number one time. It is repeating this number for each item_id listed on the open pick ticket.
We don't need to see the items.
This is taking up a huge amount of space on the report. All of the other fields are repeating also for each theoretical item Id.
How can I suppress all of the unneeded extra data...