Reports: *Still* Useless...

I said it before and I'll say it again: Reports in NS are absolutely, positively, emphatically useless!

Here's a great example.

We have two locations for inventory: Sales and Main.

I have a user who wants to simply run a report that provides them with a current list of items AND their respective serial numbers, currently in inventory (so they can match it against what's physically there).

OK, I go an run the Inventory Physical Worksheet report. so far so good. Let's add Location as a grouped item so the user can see the quantities in each location. Wow, guess what, they list them correctly except that there are quantities of zero with serial numbers (they were inventory items in Main but were assembled and are now in sales as assemblies). OK, let's put a filter in that says only show on hand quantities of 1 or more (to get rid of the zero). Wow, that worked, except now even though I see two serial numbers aside