2,299
edits
Changes
no edit summary
{{Banner-UnderConstruction}}
=Overview=
This article will run you through the process of creating one of the most useful [[Reports|reporting]] features available in a [[SmartSimple]] [[instance]]: the ability to relate information from two recordsets (tables) into a single report.
In this article, you will create one of the most useful reporting features – the ability to relate the information from two tables into a single report. In this process you will explore “joining” multiple tables. In this specific exercise, you will create a query that uses the company table and the contact table.
=Connecting Multiple Recordsets for a Report=
1. Click the 9-square menu icon on the top right of your page.
4. The '''New Report '''page is displayed, with fields for you to fill out.
:: [[File:New report pagReports multiple tables new.png|700px800px|border]]
For this example exercise, fill out the following fields with the corresponding information:
* '''Report Name: '''List Companies and Contact
* '''Report Description: '''Joins This report joins the company and contacts table.
5. Click the '''Save '''button.
:: [[File:Recordsets tab.png|750px|border]]
=Inner and Outer Joins=
There are two types of joins supported in [[SmartSimple]] – inner joins and outer joins.
: 2: [[File:Recordsets multiple table example. Add the '''following fields'''png|700px|border]]:: [[Image:Reps98.png]]:* The '''Field''' list now contains fields from both tablesSee [[Reports#Classic Report Builder - Column Settings|Classic Report Builder - Column Settings]] for more information about the report builder columns.
3. '''Build''', '''save''', and '''preview''' the report.
:: [[Image:Reps97.png]]::* The company name, city, and state information is displayed from the company table for each matching record from the contact table.::* No company details will be displayed if there are no contacts.
{{PrevNextStart}} [[Creating a Public – Internet Enabled Report]]