The workspace you just described will work great as a inquiry tool. Not all reports need printing.
I have a workspace you describe that has a calculated column for Qty on Order > Qty on hand (also a calculated column) that sorts to show shortfalls in qty then just select item to see the quantity at all locations.

David

Hi Bruce,

I just tried summarize. I never knew it existed before. Only problem is that for whatever reason the location columns all become blank and the only way you can see the quantities again in those columns is to expand the items again.

Hi David,

Exactly, the Gridview linking is great as an inquiry tool but not so good when you want to create a report. At least I'm learning what I can and can't do. That's half the battle. Now I'm moving on to POA maintain specifications.. oh joy!

POA Specifications...good time to back up what works. I've spoiled a few..... I need to spend more time working with the editor.

David

Put totals on the location columns so that GridView knows what to do when you summarize.

It works!!!

The webmaster has extended the edit time to two years; so, even the slowest typers can edit their posts now.

(This sentenced added later.)