Peter It sounds like you need a portal. I recently saw some examples of reports using portals. Very effective.
Hope this helps Bruce On Jun 25, 2011 8:12 AM, "Peter Buchanan" <[email protected]> wrote: > > > Our shipping dept tracks containers on Filemaker. Each container has a > > master record, which includes fields for: > > > > - container number (unique identifier) > > - location (physical location, port name, unlimited number of > locations, > > each with unique code) > > - type (about 15 different types (ie size), each with a unique code) > > > > I already have a report which summarises by location, then by type, and > > shows only the total number against each type, and totals by locations. > > Works fine. > > > > However, the shipping guys want a report in the following > > 'spreadsheet-type' format : > > > > Rows down the left hand side : > > Location 1 > > Location 2 > > Location 3 > > etc with totals end of each row > > > > Columns across the top : > > Type A > > Type B > > Type C > > etc with totals at bottom of each column > > > > (They require only the totals per location/type) > > > > I have started by extracting all the records into a new table, with just > > the above 3 fields for each record. > > > > Now I need some ideas, please. > > > > Rgds > > Peter > > > > >
