Hello Barb:

The Sales Analysis database provides what you need to create a report using GridView.

Are you intending to have columns like:
-Item number
-Description
-Sales for Loc 1
-Sales for Loc 2
-Sales for Loc 3
-Sales for Loc 4

You could do this with GridView.

When you create the View, choose "Adagio Composite Tables" then choose "*SR Trans with SR Description". You can select Item Number and Description but the other 4 columns will have to be Calculated columns. You may also have to Filter the records to skip the tax and miscellaneous charge lines.