• Home
  • Knowledge Base
  • Symbiant Website
  • Changelog
  • Submit A Ticket
  • My Support Tickets
Menu
  • Home
  • Knowledge Base
  • Symbiant Website
  • Changelog
  • Submit A Ticket
  • My Support Tickets
  • Home
  • Knowledge Base
  • Symbiant Website
  • Changelog
  • Submit A Ticket
  • My Support Tickets
Menu
  • Home
  • Knowledge Base
  • Symbiant Website
  • Changelog
  • Submit A Ticket
  • My Support Tickets

Symbiant One Knowledge Base

Navigation & Accessibility

  • System Navigation Overview
  • Dashboard Layout Tools
  • Filtering Data
  • Advanced Filtering

User Basics

  • Adding a Record
  • Adding an Attachment
  • Editing a Record
  • Deleting a Record (Archiving)
  • Resetting your Password
  • Generating A Report
  • Filtering on Reports
  • Linking Records Between Modules
  • Reviews & Actions

Risk Register Basics

  • Scoring a Risk
  • Risk Score Aggregation
  • Risk Relations
  • Risk Flows
  • Risk Bow Tie

Control Basics

  • Adding a Control Policy
  • Attaching a Policy to a Control
  • Attaching a Control to a Risk
  • Control Weightings
  • Activating/Deactivating a Control

Audit Basics

  • Creating an Audit Entity
  • Creating an Audit Issue Report
  • Creating an Audit Issue (Audit Tracker)
  • Generating an Audit Report

Working Paper Basics

  • Creating a Working Paper
  • Accessing Linked Records Inside a Working Paper
  • Adding an Audit Plan
  • Adding Time Sheets
  • Adding an Assessment (Surveys & Questionnaires)
  • Generating a Working Paper Report

Risk FAQ

  • What is DFA?
  • Why are some Risks highlighted in Red?

Admin Basics

  • Setup Mode
  • Managing Drop Downs and Multi Selects
  • Resetting a User’s Password
  • Database History & Restoring Historical Records
  • Restoring a Deleted Record (Archived)
  • Email Log Viewer
  • Translators – Universal Name Changing & Language Packs
  • System Menu Layout & Options

Importing Data

  • Preparing Data for Import
  • Importing Data (Generic)
  • Importing Data (Risk Register Specific)
  • Importing Users
  • Importing Divisions

Exporting Data

  • Exporting Dashboard Data
  • Exporting Divisions
  • Generating System User Details Report

Reporting Suite Tutorial

  • Creating a Word Report (Basic Data Output)
  • Creating an Excel Report (Basic Data Output)
  • Creating a PowerPoint Report (Basic Data Output)
  • Creating an Excel Tabular Report (Perfect for CSV)
  • Creating an Excel Audit Report (Audit Log Of Changes)
  • Adding a new column to an Excel Report
  • Removing a column in an Excel Report
  • Creating an Advanced Word Report (Adding Functions)
  • Advanced Report Coding (Using Owners, Divisions & Assignees in a Report)
  • Advanced Filtering on Reports (Filtering Via Code)

System Views

  • System Views (Quick Explainer)
  • Creating Your Own Custom Views
  • View Editor Tool Overview
  • Editing a View
  • Loading/Saving a Particular Users View
  • Adding a Grid Column
  • Adding Help Tips & Placeholder text

Automated Emails (Task Based)

  • Creating an Automated Email – When a record is Created
  • Creating an Automated Email – When a record is Updated
  • Creating an Automated Email – When a record is Deleted

Automated Email Reminders (Time Based)

  • Creating an Automated Email Reminder – When a Record is Due

Advanced System Functionality

  • Symbiant API

System Errors

  • System Error Messages

Admin FAQ

  • How do I view my current Licensed seats?
  • What are the differences between dropdown options? (E.g. Type & Category)

Admin Risk FAQ

  • Why are new risks not showing up?

System Setup

  • Creating Divisions
  • Creating Users
  • Assigning Roles & Divisions

SAML Single Sign On

  • Setting up Azure SAML
  • Enabling SAML for Users in Symbiant

Risk Registers (System Setup)

  • Creating a Risk Register
  • Modifying a Risk Score Set
  • Template Risk Score Sets
  • Editing a Guidance Tab (E.g. Impact Guidance)

System FAQ

  • What is SaaS?
  • Where is Our Data Center?
  • How Secure is Your Data?

Account FAQ

  • What are License Seats?
  • Can we Cancel or Upgrade at anytime?
  • Home
  • Knowledge Base
  • Reporting Suite Tutorial
  • Creating an Excel Report (Basic Data Output)

Creating an Excel Report (Basic Data Output)

Table of Contents
  • Accessing Reports
  • Report Details
  • Report Type
  • Report Assignment
  • Configuring the Report
  • Configuring the Data Source
  • Tag Generation
  • Template
  • Uploading the Template
  • Generating the Report
  • Report Output

How to create a simple excel report to output system data

Accessing Reports #

Navigate to Setup by selecting the spanner at the bottom left.

Select Reports,

Select the plus icon to create a new report,

Report Details #

First select which Module we want the report to pull data from, for example Register Risks, Controls, Incidents, Workshops etc.

Name the report,

Report Type #

Select the Type of report, in this example Excel (.xlsx)

Report Assignment #

Next we need to assign who can see/generate this report, you can select specific Users, Roles and Divisions, for our example we will allow Admin and Risk Admin users to access,

Configuring the Report #

First you need to configure a Data Source, there are three distinct types of Data Source,

For our example we shall be using a Graph based structure,

Graph – Pulls a graph based data structure with entity relationships and allows for the nested selection of attributes. The most common use!

Tabular – Pulls a flat data structure, where each column represents one value, (Like in excel)

Audit – Pulls an Audit data structure used to retrieve historical data about record change history.

Retracted – Pulls a Retracted Record structure used to retrieve a list of any records within a module that were deleted (Archived)

Auth [Users] – Pulls an entire list of all User details, Roles, Divisions etc.

Configuring the Data Source #

Name the Data Source, ensure a good naming convention here! In our example as we are pulling the Risk Details we will just name it RD,

Next select the Configure option,

The data source configuration screen shall be shown, here is a list of all attributes we could pull into our report,

Note: To make this easier to read select the Translate option at the top right!

Next tick which attributes you want to have pulled into your report, drop downs and nested items such as the Risk Register, will need their Root Attribute and Text value selecting,

Once you have finished selecting the attribute you want to use, select the OK at the bottom right,

Tag Generation #

When attributes are selected within a Data Source, Tags get created, you need these for the excel template, to access these select, Show Available Markers,

All the tags will be listed here,

Template #

Within excel, create a template, this can be in any design, layout and style you wish,

Copy and paste the Tags generated by the system into your template, as shown below,

Uploading the Template #

Once your template is created, navigate back to the system. Select the Choose File option and select your template,

Now your template is uploaded, and the Data Source is configured the report is ready!

Save the report at the top right.

Generating the Report #

Exit Set Up mode from the bottom left,

Select Reports,

Find your report and select Generate!

Report Output #

Your report should generate and the data will automatically be loaded in.

Did this help?
Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
Require Additional Information? Please Contact Support

How can we help?

Updated on June 27, 2022
Creating a Word Report (Basic Data Output)Creating a PowerPoint Report (Basic Data Output)
Table of Contents
  • Accessing Reports
  • Report Details
  • Report Type
  • Report Assignment
  • Configuring the Report
  • Configuring the Data Source
  • Tag Generation
  • Template
  • Uploading the Template
  • Generating the Report
  • Report Output
  • 20-22 Wenlock Road
  • London
  • N1 7GU

Telephone Numbers

  • UK - 020 8895 6410
  • Support - 020 3821 1993 option 2
  • USA - 347 991 7130

Information

  • Home
  • Knowledge Base
  • Symbiant Website
  • Submit A Ticket
  • My Support Tickets

Symbiant 2022 - Designed by the Symbiant Team

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
SAVE & ACCEPT