Introduction to Reporting

Introduction to Reporting

Workbooks provides an extremely powerful and flexible reporting engine which allows you to extract information from your database in the way that best suits your business.

Unless your System Administrator has changed the Capabilities given to you, everyone is able to create Reports. However, if you want other Users to see your Reports, you must share them with them.

Reports

Reports display a collection of information from the records in your Workbooks system. You can create simple reports to list a set of fields, being returned in the form of columns and rows, much like a spreadsheet. Or you can build a summary report which summarises information, and groups information together. You can use formulae such as totals, counts or averages.

Remember, by default, reports don’t have any criteria, which means all records of that record type will be displayed e.g. All Opportunities in the database will be displayed. Add Criteria to return just the records of interest.

Using Workbooks you can also join together records of different types, allowing you to create reports which contain fields from both record types. For example, you could create a report from the People record listing the persons name and email address and then using criteria, limit that report to only include People who have Director in their job title. In addition, you could join to their employer’s Organisation record and include the Revenue from the Organisation record.  Then, for example, you could apply a criterion to the Revenue field to show only Organisations with revenues of £5m or more.  This allows you to build a report of all People in your database whose job title includes the word ‘Director’ that work for organisations with revenues of more than £5m.

Views

Important: It’s important to note that reports have multiple views:

• Details view – This view lists all the data you need to see, perform calculations on, summarise or group by.
• Summary views – Summary views are created from the Details view. Consider an Opportunities report. You can group by the Assigned to field, then Split the data by Stage. This report gives you a breakdown of what opportunities each sales person is working on, and what Stage the opportunities are at. It’s a classic Sales Pipeline report.

Automation

Bulk Actions can be carried out on Reports using a Script which can be run against the data set identified in the Report. For example, you may wish to create an activity reminder for any opportunities not updated in the last 7 days that don’t have any future/scheduled follow-up activities.

Your Sales Team will then find new activities in their My Activities list. The report returns any opportunities that fit the criteria. The script performs the part of the process where the list of Opportunities are processed, and activities are created and linked to those Opportunities. This is of course, just one example, and the requirement varies by each customer. If you’ve tried building a Report and can’t quite get the output you were looking for, please ask your System Administrator to contact Workbooks Support for some advice. To learn more about report-building, why not book a place on one of our 2-day Reporting courses?

Wrapping text

Some text can be difficult to read in grid form due to it being cut off (after a certain length of character). Wrapping the text makes it more presentable and easier to read. This is available on all report grids.

When editing a report, the view tab contains a ‘Style’ section. This section gives the ability to configure both the header and the grid body to wrap the text showing multiple lines of data. The options to wrap the text can be applied to the two areas independently with the option to align the text to top, middle or bottom of the header or row.

The maximum number of lines can be set to a numerical value. Unless dealing with large quantities of text, a value of 5 should be sufficient.

Using the styling section, you can wrap both column headers and the column values and set how you want the values to be aligned.

When you run the report, you will notice that the text will appear wrapped. The number of lines of text will depend on what was specified previously.

Charts

Charts are always based on a Report. Workbooks supports the following types of charts: Pie Chart, Bar Charts, Line Charts & Dials.

Dashboards

Dashboards enable you to bring together management information from Reports and Charts in a central place. You can create as many Dashboards as you require and share them with colleagues and you can drill down through the Dashboard to the underlying report data. You can also collate a number of Dashboards on a Springboard.