I was given a database by my company to add a layout to. The database is for purchase orders and it goes back several years. My company wants a layout created in which they can view all the items purchased sorted by the name of the company purchased from with a total for each company. There are 4 fields (company_name, date, total, and item). The summary of the total would add up all the TOTAL fields for each company (this is how much each purchase amounted to). I tried to use the automated wizard that comes with filemaker but it isn't showing up correctly. In browse mode i have individual records and in preview mode it is all on one sheet. This is what I wanted however I only want to show the data for THIS YEAR. I performed a search for everything with 2003 but when i do that It loses the format of company name and everything below it. Please help!

-Shana

Do the search before you change to the report layout in preview mode.