Hi,
I have a report showing pallets and products (SKUs) on the pallets (1 product per pallet, mulitple pallets)
This has been grouped by products and sorted by Use By Date of the pallets.
I've then suppressed details of all pallets that aren't in the top 10% of overall count of pallets (so if product group 1 has 500 pallets, onlt the oldest 50 would display)
and hence, I need the grouping in place.
Problem now is though that the report is sorted by the group (product) but I need it to be sorted by the location the pallet is stored in, regardless of the product.
Is there a way, maybe using subreports, that I can use the data from this report and re-sort it? I've tried subreports, but only seem to be able to get summaries to be shared between main and sub, not the actual line details.
My only other option I can see is exporting to excel and finishing the job there, but would like to keep it all in Crystal
Any suggestions?
thanks