Book Image

Sage ACT! 2011 Dashboard and Report Cookbook

Book Image

Sage ACT! 2011 Dashboard and Report Cookbook

Overview of this book

Sage ACT! is the top selling CRM software application, and it helps businesses to centralize contact information, organize their calendars and notes, and ultimately maximize contact relationships to optimize business efficiency and profitability. In ACT! 2011, a variety of new dashboards and reports are available for producing graphical representations of client information and for measuring the success of your sales force. This cookbook is full of practical and immediately applicable recipes that will take you from being an ACT! report and dashboard novice to a report-writing pro in no time. The recipes will show you how to create custom dashboards and reports, as well as utilize the new templates available in recent ACT! versions. You will learn to use ACT!'s Report Editor and Dashboard Designer so that you will be able to easily view important information about your business and your sales force. The recipes begin by covering the most basic elements of the ACT! reports and continue to include several recipes that will guide you through creating brand-new reports. If you have an ACT! database, you need to be able to access it quickly and logically; this book will help you do just that.
Table of Contents (16 chapters)
Sage ACT! 2011 Dashboard and Report Cookbook
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface

Filtering based on a contact field lookup


The simplest form of filtering for a report is to limit the report to only a portion of the contacts in your database. That way you only print the records that meet specific criteria. This type of filtering is done prior to running the report, and as such isn't directly part of running the report, but it's necessary for the filtering process in the report itself.

Getting ready

Before you create the lookup, you need to decide which report you plan to run, because the lookup needs to relate to the report you're creating. You also need to decide the criteria for the lookup. The example we'll use is the Contact Directory report and the lookup will be based on City and State.

How to do it...

  1. 1. On the Detail Contact screen, right-click on the State field and choose Lookup State.

  2. 2. If you don't see the full dialog box, click on Show more options. Verify the field type and type of query (Starts With) and use the dropdown to select the desired State. Make sure...