• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Creating Data Reports

Chapter 5. Creating Data Reports

No matter how carefully you design a database or how accurately data is entered into it, your database remains an underutilized resource unless you can mine it for the precise information you need. Performing this effective information retrieval is a two-step process, covered in this chapter.

The first step is to isolate the set of information you need. You already know how to search on one field so that information will be organized in a specific way. Any time you need to see a mailing list by state or city, instead of alphabetically or in the order names were entered, you're performing a simple search. You may also know that you can add more criteria to a search in order to narrow down this information. For example, if you want to find which customers in Newport, Rhode Island received mailings in April and June but not in May, and whether they purchased anything in response, a simple search is not enough. Fortunately, FileMaker Pro offers search tools for zeroing in on this exact set of information (known as the found set) and sort tools for organizing the found set in the most effective manner.

Once you have chosen a found set, you need to summarize it on a layout to display it for yourself and others. A summary report can show how many customers in the group responded, tell you how much they spent by month, and total the sales per individual—giving you quick feedback for decision-making.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint