I figured out that I can export physical inventory worksheets to get the result I'm looking for, but still interested in knowing how to produce reports with location columns in Gridview.