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

Running a report from the Report view


Entering information into your database is the hard part. The easy part comes from running a report so that you can better analyze that data.

Getting ready

The only thing you'll want to do before heading for the Reports view is to create a Lookup of contacts specific to your reports. For example, if you want to run the Source of Referrals report to find out how all your top customers found out about you in the first place, you'll want to create a Lookup for Top Customers.

How to do it...

  1. 1. Navigate to the ACT! Reports view.

  2. 2. Select the report you wish to run from either the Favorite Reports or Report List.

  3. 3. Click the Run Report button on the Report view toolbar. Alternatively you can double-click the name of the report you want to run. Depending on the report you choose, you'll see a Define Filters dialog box similar to the one shown previously.

  4. 4. Click OK to run the report.

  5. 5. Click the red X to close the report when you're finished viewing it.

How it works...

The ACT! Report will include only those contacts that are included as part of your current lookup. In addition, as you run a report you can filter the contents of that report. For example, you might create a lookup of all of your customers, and then filter your report to include only notes that you've added about those customers in the last 30 days.

There's more...

You can learn about the various filtering options in the next chapter. You can permanently alter the filtering options in a report from the Report Designer, which we'll discuss later in this book. For example, you may always want to run one of the Opportunity reports for the prior month, or save your pipeline as a PDF file.

Limiting access to Report Data

Rightfully so, many ACT! users worry about the security of their data. As a business owner you might be concerned that one of your ACT! users could run a report and then run off with your data. All of the ACT! Reports are automatically added to the database and appear in the Report view. Any users who can access the database can run the report. However, if you are using ACT! Premium and have limited the access rights at the contact level, those access rights cascade down to the report level.

For example, you may be worried that one of your sales people could run the Contact Report and consequently have a nice listing of all of your customers. However, if you have limited the access to those customers so that your sales person can't access them, the sales person can still run the report, but it will not contain any of the contacts to which he has no access.