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

Preface

ACT! is the best-selling contact manager software in the market today. ACT! 2011 includes a variety of new Dashboards and reports that allow you to easily view important information about your business and 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 utilize the existing reports and Dashboards. You will also learn to use ACT!'s Report Writer and the Dashboard Designer so that you will be able to modify the existing report and Dashboard templates or create new ones, based on your own specifications.

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 your information quickly and logically; this book will help you do just that.

What this book covers

Chapter 1, Exploring the ACT! Reports, serves as the most basic introduction to the ACT! reports. You'll become familiar with where to access reports and learn about the existing ACT! Reports.

Chapter 2, Filtering Data in Reports, covers the various filtering options available for the ACT! reports. You'll become familiar with the filtering options available prior to running a report along with the filter options within the actual report template.

Chapter 3, Creating a Quick Report, shows how to run the various quick reports available in the ACT! program. You'll be shown how to set up, control headers and footers, and run the various quick reports.

Chapter 4, Working with the Report Editor, introduces you to the structure, tools, and best practices for creating a basic report template. You will become familiar with using the properties tools to control the content and appearance of the report.

Chapter 5, Subreports and Scripting Techniques, continues showing you how to design a report. Here you move to the more advance techniques of report design working with custom sections and script programming.

Chapter 6, Labels and Envelopes, covers labels and envelopes which are specialized forms of the ACT! Reports. You'll be shown how to customize the standard label and envelope templates and how to design templates for custom sizes of both, labels and templates.

Chapter 7, Working with the ACT! Dashboards, serves as the most basic introduction to the ACT! Dashboard components. You'll become familiar with how to access the Dashboards, how to print them, and how to copy them into other documents.

Chapter 8, Filtering Dashboards, shows you how to filter the information that you see in the Contact, Activity, Opportunity, and Administrative Dashboard components.

Chapter 9, Editing Existing Dashboards, explains how to permanently change the various aspects of a Dashboard component including the display type, headers and footers, legends, totals, scales, and limits.

Chapter 10, Working with the Dashboard Designer, explains how to create a brand new Dashboard. You'll learn how to add and remove columns and rows to a Dashboard, add components, and custom data charts to a Dashboard and rearrange the dashboard components.

What you need for this book

You need to have ACT! versions 2009, 2010, or 2011 installed on your computer. And, although you can work with the demo database that automatically installs on your computer when you install ACT!, you'll have the best results if you work with your own database.

The chapters on reports use the demo database for all the screenshots.

Who this book is for

If you are an ACT! end-user who wants to learn about the existing reports and Dashboards available in ACT! 2009, 2010 and 2011, then this book is for you. If you are an ACT! administrator who wants to make changes to ACT!'s Dashboard and reporting features, you will also find this book helpful. No prior ACT! knowledge is necessarily required; however you'll find it helpful to have a good working knowledge of how to add data into ACT!, or to work with an ACT! database that has already been populated with data.

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "From the Save As window that opens you can choose to save the report in Adobe (.pdf), Rich-Text (.rtf), HTML (.html) or Text (.txt) file format".

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Click OK to run the report".

Note

Warnings or important notes appear in a box like this.

Note

Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to, and mention the book title via the subject of your message.

If there is a book that you need and would like to see us publish, please send us a note in the SUGGEST A TITLE form on www.packtpub.com or e-mail.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Errata

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/support, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.

Piracy

Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.

Questions

You can contact us at if you are having a problem with any aspect of the book, and we will do our best to address it.