- 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 Pre-populated Report
Tip
Modifying an existing report is a quick way to create a series of similar but different reports without changing the original report.
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.
Pre-populated reports are useful for creating a report with a set of commonly used columns - it's quicker than adding the columns manually. If any columns are not of interest, simply remove them from the report by clicking the red cross and equally you can add more columns if required.
Please note, by default, pre-populated reports don't have any criteria, which means all records of that record type will be displayed. Add Criteria to limit the results to a particular set of records.
How to create a pre-populated Report
Click Start > New > Report > A new pre-populated report and select the record type on which you want to base your report.
1. Fill in the fields on the Main tab:
- Give the report a clear Name - Keep it simple yet accurate. This will ensure the report is easy to locate e.g. "Opportunities created this financial year".
- Add a meaningful Description - This makes it easy for you and colleagues to understand the report's purpose e.g. "List of opportunities created this financial year, showing their value and the gross margin".
- Set a Category - The category field makes it easier to group and find reports based on their purposes. You can select from one of the pre-defined categories, or add/amend the categories picklist within Configuration.
- Click Save.
2. Details View > Columns Tab:
The Details tab displays a preview of the report. Workbooks automatically formats columns. For example, Amount is formatted as a currency and a total has been added at the bottom of the Amount column.
NOTE: The total shown is the total for ALL the rows in your report, not just the ones visible in the preview window. If your report contains more than 1,000 rows of data, the total won't show automatically (and you'll see the word 'Calculate' in greyed out letters, but you can make it appear simply by clicking on Calculate).
3. Details View > Criteria Tab:
You now have a report of all Opportunities on your database. You can sort, reorder or filter this information as you would with any other grid in Workbooks. To refine the results to show only those that are open, click Criteria > Add criteria. From the picklist, choose Record state.
This will activate the Operator field. Click on the dropdown to see the operators you can apply. To select only open Opportunities select is and in the next box that appears, specify Open. Click Save & Close then click Refresh preview to update the results displayed.
NOTE: This is the Details view, which simply lists opportunities and adds a sub-total at the foot of the Amount column. The Opportunities are not yet Grouped / Summarised. This is done in the next stage, where a Summary View is created.
4. Details View > Automation Tab:
Click here to view information on Automation.
5. Summary View:
Adding a Summary view allows you to Summarise / Group the Opportunities listed in the detail report by a column, in this case Opportunity Stage. Summarising by Opportunity stage will give a breakdown of values for Opportunities at each Stage.
- Click Add Summary View and select Add Summary View from Details.
- Click Add value column > Subtotal column.
Next to Column choose Amount. You'll see that the report defaults to calculating the total and the tick in the checkbox next to Display summary indicates that a grand total will be shown at the bottom of the column.
Next to Group by choose Opportunity Stage. Click Save & Close.
When you refresh your report view you'll see that you now have a summarised report of open opportunities, grouped by opportunity stage, showing sub-totals for the amount at each stage, as well as the total value for all the open opportunities.
Drilling and Filtering
If you want to see more details about the opportunities that have now been summarised, you can drill into them (which in effect provides you with a filtered list of the opportunities in your details report). Hover over the right-hand side of one of your columns and click on the down arrow. Depending on exactly where you click, you can choose to Filter the results or Drill into the results, as shown below:
NOTE: Drilling and filtering will only work if the checkbox next to Details on the report main tab is ticked.
... and here's the result. You've drilled into the data and the filtered results from the Details tab are displayed.
Automation (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.
If you still require any more assistance after reading this article, please see a video on how to create a new report here.
Related content