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.

Related Content you might be interested in

Current Title:

Small book image
Sage ACT! 2011 Dashboard and Report Cookbook
Feb, 2011 | 216 pages
No titles found
Table of Contents (16 chapters)
Sage ACT! 2011 Dashboard and Report Cookbook
Sage ACT! 2011 Dashboard and Report Cookbook
Credits
Credits
About the Authors
About the Authors
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Exploring the ACT! Reports
Exploring the ACT! Reports
Introduction
Using the ACT! Reports menu
Using the Reports view
Running a report from the Report view
Choosing a Report Output Option
Editing Reports in the Reports view
Keeping a list of Favorite reports
Finding the default location of the ACT! Reports
2
Filtering Data in Reports
Filtering Data in Reports
Introduction
Filtering based on a contact field lookup
Filtering Contact reports
Filtering based on a contact activity lookup
Filtering Notes and History in reports
Filtering activities in reports
Filtering Groups reports
Filtering Company reports
Filtering Opportunity reports
Presetting filters for most used option
3
Creating a Quick Report
Creating a Quick Report
Introduction
Setting preferences for the quick reports
Selecting and organizing the columns for a contact list quick report
Printing the contact list quick report
Printing the History tab quick report
Printing the contact detail view quick report
Exporting the Opportunities List View to Excel
4
Working with the Report Editor
Working with the Report Editor
Introduction
Converting ACT! 6 custom reports
Choosing a template type and setting defaults
Adding fields to template and basic formatting
Naming field objects and individual field formatting
Positioning fields and labels
Adding a custom field and creating a basic script
Adding sections for sorting and grouping
Using sections for sub-totaling and totaling
5
Subreports and Scripting Techniques
Subreports and Scripting Techniques
Introduction
Formatting a List Type report
Adding subreports to a report
Adding fields to the secondary contacts subreport
Adding fields to the history subreport
Scripting basics by example
Reverse engineering a set of complex scripts
6
Labels and Envelopes
Labels and Envelopes
Introduction
Editing a standard envelope
Adding a logo to an envelope
Creating a custom envelope
Creating an xx64 label template
7
Working with the ACT! Dashboards
Working with the ACT! Dashboards
Introduction
Getting familiar with the Dashboard layouts
Accessing information from Dashboards
Copying Dashboard information to other products
Printing Dashboards
Making Dashboards the default startup preference
8
Filtering Dashboards
Filtering Dashboards
Introduction
Filtering the Contacts Dashboards
Filtering the Activity Dashboards
Filtering the Opportunity Dashboards
Filtering the Admin Dashboard
Changing the Dashboard Data
9
Editing Existing Dashboards
Editing Existing Dashboards
Introduction
Cloning an existing Dashboard
Changing the Dashboard display type
Changing the Dashboard default filters
Changing the Dashboard headers and footers
Changing the Dashboard legends
Changing the Dashboard totals
Changing the Dashboard scales and limits
Setting a Dashboard target
Modifying the closed sales to date component
Changing the Dashboard data charts
10
Working with the Dashboard Designer
Working with the Dashboard Designer
Introduction
Creating a new Dashboard
Adding or removing columns and rows
Creating wider components
Adding components to the Dashboard
Adding data charts to the Dashboard
Changing the order of the Dashboard components

Selecting and organizing the columns for a contact list quick report

In this task, we continue working with the Contact List Quick Report. The contact list is able to display all the fields in the contact table. While possible, in most cases this would be impractical. To create a meaningful report you need to decide which fields you want to show in the report. Because you will be printing the contact list, make sure the contact list is showing the fields that you want and that they are arranged in the desired order. In this task we will set up a name and address list.

Getting ready

There isn't any preparation required for the contact list quick report other than having an ACT! database open.

How to do it…

  1. 1. In the navigation bar, on the right-hand side of the screen, click on Contacts.

  2. 2. In the tool bar, click on List View button.

  3. 3. Anywhere in the List View, right-click and select Customize Columns....

  4. 4. In the Customize Columns dialog, add fields to the list by clicking in the desired...

Previous Section
End of Section 4
Next Section