- Welcome to the Knowledge Base
- Introduction
- Training
- Getting Started
- Preferences
- Activities
- Cases
- Forecasts & Quotas
- Importing Data
- Leads
-
Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
- Event Management
- Compliance Records
-
Spotler Integration
- What is Spotler?
- Navigating your Spotler homepage
- GatorMail
-
GatorLeads / Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- Reporting incorrect Leads created through Web Insights
- Reporting on Web Insights data
- Using UTM Values
- Why aren’t Online Activities being created in the database?
- Why is GatorLeads recording online activities in a foreign language?
- GatorSurvey
- GatorWorkflow
- GatorPopup
- Opportunities
-
Integrations
- Mapping
- Electronic Signing Tools
- Creditsafe Integration
-
Zapier
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
-
Setting up Zaps
- Posted Invoices to Xero Invoices
- Xero payments to Workbooks Tasks
- New Case to Google Drive folder
- New Case to Basecamp Project
- New Workbooks Case to JIRA Ticket
- Jira Issue to new Case
- 123FormBuilder Form Entry to Case
- Eventbrite Attendee to Sales Lead and Task
- Facebook Ad Leads to Sales Leads
- Wufoo Form Entry to Sales Lead
- Posted Credit Note to Task
- QuickBooks Online
- Survey Monkey responses to Tasks
- Multistep Zaps
-
Email Integrations
- Email Dropbox
- Workbooks Exchange Server Sync
- Workbooks Outlook Connector
- RevenueGrid Intelligence and Engage
-
Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
-
Outreach
- Installation
- Outreach Authentication
- Sync People to Outreach Prospects
- Sync Organisations to Outreach Accounts
- Sync Workbooks Opportunities to Outreach
- Sync Tasks/Activities from Workbooks to Outreach
- Sync Outreach Sequences to Workbooks
- Sync Outreach Sequence States to Workbooks
- Sync Outreach Sequence Step Numbers to Workbooks
- Sync Prospects/Accounts/Opportunities from Outreach to Workbooks
- Sync Outreach Tasks/Calls/Meetings to Workbooks
- Scribe/Workbooks Connector
- RingCentral
- Auditing
- Comments
- People & Organisations
- Projects
-
Reporting
- Introduction to Reporting
- Using Reports
- Charts
- Exporting Reports
- Advanced Reporting
- Report Snapshots
- Dashboards
-
Transaction Documents
-
Introduction to Transaction Documents
- Displaying & Adding Transaction Documents
- Copying Transaction Documents
- Transaction Documents Fields Help
- Transaction Documents Line Items Help
- Printing & Sending Transaction Documents
- Managing Transaction Document Currencies
- Managing Transaction Document Statuses
- Setting a Blank Default Currency on Transaction Documents
- Credit Notes
- Customer Orders
- Invoices
- Quotations
- Supplier Orders
- Contract Management
- Sagelink
-
Introduction to Transaction Documents
- Auditing
-
Configuration
- Introduction to System Administration
- Users & Security
- Preferences
- Database
- Accounting
- Email & Integration
-
Customisation
- Creating & Modifying Picklists
- Theme
-
Record Types
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- Automation
- PDF Configuration
- Contact Support
- Releases & Roadmap
Creating a Blank Report
After selecting to create A new blank report, you'll see the full list of 'object types' (ie, types of record) that you can report on. It is important to consider what type of record you want to start building your report from.
Below is an example of creating an Opportunity Report showing the total value of all open Opportunities on your database, summarised by the stage the Opportunity has reached. This an example of the sort of report we might be aiming for:
Click Start > New > Report > A new blank report.
Tip
Click on Refresh preview each time you add a column, criteria or summarise your data.
This enables you to check your report is building correctly and 'sense-check' that it's displaying the results in the way you require.
In this example, click Opportunities but for other Reports, choose the appropriate object type you want to start your Report on. Start by giving your Report a name and description. On the right are three tabs:
- Columns - where you choose which fields appear as columns on your Report.
- Criteria - where you can specify parameters to limit the Report to particular segments of data.
- Summarise by - where you can summarise (or group together) data.
Add columns
In the Columns tab click Add column from Opportunities. Click on the arrow next to Column to display a list of all the fields you can choose to add to your Report.
From the list choose Opportunity name > Save & Close. To add new columns, click on Add column from Opportunities again and use the arrow next to Column to choose the field(s) you want to display. You can also type ahead to search for a column. This does a 'contains' search, so if you are looking for 'start date' you could just type 'date' and it would show you any columns with 'date' in it. Repeat this process until you have all the columns you need.
For this example, add columns for Amount and Opportunity stage. If you want to see what data your Report will show as you build the Report, click on Refresh preview in the lower half of the record after you add each column.
NOTE: Some of the column options have a small black arrow next to them
These are known as 'breadcrumbs' and enable you to 'drill through' to another object (record) types and use the fields from different record types within your report.
Apply Criteria
You now have a Report of all Opportunities on your database. You can sort, reorder and filter this information as you would with any other grid in Workbooks. To refine the results to show only those that are open, click on the Criteria tab > Add criteria from Opportunities. From the picklist, choose Opportunity stage. This will activate the Operator field. Click on the dropdown to see the operators you can apply. To see only open Opportunities select does not contain. In the next box that appears, specify the parameters, you want to apply. In this case, type in Closed (this would remove all those Opportunities that are either Closed Won or Closed Lost). Click Refresh preview to update the results displayed. Click Save & Close.
NOTE: You can apply an 'or' operator to criteria by using a comma. For example, if you want to find Opportunities that are either at Stage 1 or at Stage 2, you would enter in the Text box: Stage 1, Stage 2.
Summarise
You now have a Report that lists all the open Opportunities on your database, showing the amount attributed to each Opportunity as well as the Opportunity stage name for each one. To summarise the Report by what stage the Opportunity has reached, add a Summary view by clicking Add summary view. From the dropdown picklist choose Amount (home currency), choose to group by stage towards the bottom of this page, then click Save & Close.
Click Refresh preview. Now the Report shows the total value of Opportunities on your database summarised by Opportunity stage.
NOTE: Now that the Report has been summarised, there's no need to display the Opportunity name column. You can remove it from the Report by clicking on the delete symbol next to Opportunity name in the Report builder window.
When your Report is complete click Save & Close. To open it again, click Start > Reporting > My Reports. Click on the hyperlink to open it. If you want to modify the Report further you can click on Edit this Report and make any changes you require.
Running Processes from Reports
It's possible to perform a Bulk Action on a Report by running a Script against the records identified in the Report. For information on how to set this up, click here.
Related content