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

Editing Reports in the Reports view


It's nice to keep things organized, especially when you're working with over 60 reports. By tweaking the Reports view, you will be insured that you will be able to find exactly the report you want.

Getting ready

Before you go about changing the Reports view, it's a good idea to familiarize yourself with the various reports so that you know which ones will work for you. When you install ACT! a demo database installs as well that is populated with lots of data. You might want to open the demo database and preview any of the reports that sound appealing. Once you have had a chance to view them, jot down a list of your favorites.

How to do it...

  1. 1. Navigate to the ACT! Reports view. Select a report from the Report List by clicking on it once.

  2. 2. Click on the Edit Properties button. The Edit Properties dialog box will open like the following screenshot:

  1. 3. Enter a new name for a report in the Name field that will make it easier for you to identify in the future.

  2. 4. (Optional) Enter a new description for the report in the Description field.

  3. 5. Click OK to close the dialog box and save your changes.

How it works...

As you modify the properties of an item listed in the Reports view, the corresponding report will update as well if you had already added it to the Favorite Reports.

There's more...

The main reason for changing the report properties is to help you organize the reports in a way that makes sense to you. For example, many companies are used to using what they call a Face Sheet and may want to rename the Contact Report accordingly.

Changing the sort order in the Report view

The reports are listed in alphabetical order which means that the Group reports (at least those that begin with the word Group) appear together in the list and the Opportunity reports beginning with the word Opportunity appear together.

Wouldn't it be nice if all the reports appeared together according to their type? Well, they can. Simply tweak the description of each report slightly by adding Contact to the front of all the Contact reports, Opportunity in front of all the Opportunity reports, and so on. You can then sort the report list by Description by clicking the Description column header and have your reports neatly sorted by category.

Deleting a Report

There's another button lurking on the Reports View icon bar—the Delete Report button. If you delete a report it is permanently removed from the database which means that none of the other users will be able to access it. Deleting a report is not the same thing as removing a report from the Favorites list, which you will learn later in this chapter.

Rather than permanently deleting a report, consider renaming it by placing an X in front of it so that all the reports you don't need fall to the end of the Report List.