Changes

Jump to: navigation, search

Reports Based on Multiple Tables - Overview

90 bytes added, 17:16, 8 July 2019
no edit summary
{{Banner-UnderConstruction}}
=Overview=
In this This article, will run you will create through the process of creating one of the most useful [[Reports|reporting ]] features available in a [[SmartSimple]] [[instance]]: the ability to relate the information from two recordsets (tables ) into a single report. 
In this process specific exercise, you will explore “joining” multiple tablescreate a query that uses the company table and the contact table.
In this exercise, you will create =Connecting Multiple Recordsets for a query that uses the company table and the contact table.Report=
1. Click the 9-square menu icon on the top right of your page.
:: [[File:Company and contact inner join.png|250px|border]] 
 
* The '''Organizations '''recordset will report on company information that you have entered into the system, including all organization-specific [[Custom Fields]] that are related to organizations.
* The '''Contacts '''recordset will report on all contacts ''outside ''of your organization (although this does not automatically mean that they are [[External|}external]] [[User|users]]). This table will include all contact-specific and [[User Role|role]]-based [[Custom Fields]]. 
2,299
edits

Navigation menu