Anyone know how to create inventory report however have the locations as columns instead of rows? really frustrating there doesn't seem to be a way to do this?

Use a summary search and formulas Make your results of your saved search the following Item summary type GROUP Description summary type GROUP Formula numeric summary type MAX (CASE WHEN {inventorylocation} = ‘Location 1’ THEN {locationquantityonhand} END Formula numeric summary type MAX (CASE WHEN {inventorylocation} = ‘Location 2’ THEN {locationquantityonhand} END Formula numeric summary type MAX (CASE WHEN {inventorylocation} = ‘Location 3’ THEN {locationquantityonhand} END (Repeat for all locations/inventory fields you want)

You can use the Current Inventory Snapshot

@MGBC will give that a go... @Edgar Valdes any idea how to remove the totals column from the report?