HI AlI have set up a BAQ report to show shipments and the country its gone to.
im now creating the report itself, i want it to just show somthing like this
Customer - Country - Amount of shipment (For example)
Matt - United Kingdom - 5
Matt - Spain - 2
at the moment its listening every shipment so all 5 records show, how do i go about not showing them all
see the picture below i’d want it to just say AMO609 - United Kingdom - 11
Without knowing exactly how you have it set up, it’s a little more difficult.
I made a quick one with ShipHead connectod to ShipTo.
I counted number of Packs sent to each country.
Calculated field set up like this:
I did have to set the results up as distinct, but then you get:
Hopefully that gives you enough to point you in the right direction.
I’d give it a shot with SSRS tablix grouping. There are a few options and you can get pretty fancy but a little poking around will get you where you’re headed.
Instead of doing the windowing function, just group by the country (check the box on the field selection). Then you don’t need to use the “Distinct”.
count (shiphead.PackNum)