Difference between revisions of "Creating a Basic Report"
From SmartWiki
Paul Dimerin (talk | contribs) |
|||
| Line 1: | Line 1: | ||
{{SeqReportPageHeader}} | {{SeqReportPageHeader}} | ||
| − | |||
In this article, you will build a report that lists all your contacts displaying their first name, last name, and title. | In this article, you will build a report that lists all your contacts displaying their first name, last name, and title. | ||
| Line 16: | Line 15: | ||
[[Image:Repor.png]] | [[Image:Repor.png]] | ||
| − | + | ||
This window contains the following settings: | This window contains the following settings: | ||
| Line 25: | Line 24: | ||
* '''Lock''' - The "Do not rebuild report" checkbox indicates that the report should not be rebuilt in case of a custom Report Template, it will give an alert when the '''Report Builder''' button is clicked. | * '''Lock''' - The "Do not rebuild report" checkbox indicates that the report should not be rebuilt in case of a custom Report Template, it will give an alert when the '''Report Builder''' button is clicked. | ||
* '''Report Builder''' - This button opens the '''Report Builder'''. | * '''Report Builder''' - This button opens the '''Report Builder'''. | ||
| − | * '''[[Recordsets]]''' - This tab is used to select which tables are required in the report, the relationships between the tables, and the primary table. | + | * '''[[Recordsets]]''' - This tab is used to select which tables are required in the report, the relationships between the tables, and the primary table. The primary table determines how data will be joined when multiple tables are selected. |
* '''Advanced''' - This tab shows advanced settings for the report. See this page for details on settings: [[Edit Report Page: Advanced Settings Tab]] | * '''Advanced''' - This tab shows advanced settings for the report. See this page for details on settings: [[Edit Report Page: Advanced Settings Tab]] | ||
| Line 31: | Line 30: | ||
[[Image:Repor2.png]] | [[Image:Repor2.png]] | ||
| − | + | ||
4. Set the '''Category''' to '''Training Reports'''. | 4. Set the '''Category''' to '''Training Reports'''. | ||
[[Image:Repor3.png]] | [[Image:Repor3.png]] | ||
| − | + | ||
This will create a new entry in the category combo box – '''Training Reports'''. | This will create a new entry in the category combo box – '''Training Reports'''. | ||
[[Image:Repor4.png]] | [[Image:Repor4.png]] | ||
| − | + | ||
5. Set the '''Description''' to '''List Contacts - All'''. | 5. Set the '''Description''' to '''List Contacts - All'''. | ||
[[Image:Repor5.png]] | [[Image:Repor5.png]] | ||
| − | + | ||
6. Click the '''Save''' button. | 6. Click the '''Save''' button. | ||
| Line 49: | Line 48: | ||
[[Image:Repor6.png]] | [[Image:Repor6.png]] | ||
| − | + | ||
It will not be possible to preview this report, as you have not selected any table(s) nor selected any fields from the tables in the '''Report Builder'''. | It will not be possible to preview this report, as you have not selected any table(s) nor selected any fields from the tables in the '''Report Builder'''. | ||
| Line 55: | Line 54: | ||
An enhanced version of the report builder has entered the beta stage. The new report builder allows for greater control of reports and features a more intuitive user interface. | An enhanced version of the report builder has entered the beta stage. The new report builder allows for greater control of reports and features a more intuitive user interface. | ||
| − | *When creating a new report, a user now has the option of using the classic report builder or the new report builder. | + | * When creating a new report, a user now has the option of using the classic report builder or the new report builder. |
[[Image:Neo_report_builder.png ]] | [[Image:Neo_report_builder.png ]] | ||
=Report Tabs= | =Report Tabs= | ||
| − | |||
In addition to the '''Delete''' and '''Preview''' buttons, a new set of tabs are displayed at the top of the report window. | In addition to the '''Delete''' and '''Preview''' buttons, a new set of tabs are displayed at the top of the report window. | ||
| Line 70: | Line 68: | ||
* '''[[Custom Export]]''' – used to create a custom export for the report. | * '''[[Custom Export]]''' – used to create a custom export for the report. | ||
* '''[[Report Template]]''' – used to control the layout and formatting of the report. | * '''[[Report Template]]''' – used to control the layout and formatting of the report. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | {| | |
| − | + | |- | |
| − | + | ||@navbar@ | |
| − | + | |- | |
| + | ||@header@ | ||
| + | |- | ||
| + | ||@rows@ | ||
| + | |} | ||
* '''Charts''' – used to create one or more charts to be associated with the report. | * '''Charts''' – used to create one or more charts to be associated with the report. | ||
| − | {{PrevNextStart}} [[Accessing Reports in SmartSimple]] | + | {{PrevNextStart}} [[Accessing Reports in SmartSimple]] |
| − | {{PrevNextMid}} [[Adding a Table to a Report]] {{PrevNextEnd}} | + | {{PrevNextMid}} [[Adding a Table to a Report]] {{PrevNextEnd}} |
[[Category:View It]][[Category:Reports]] | [[Category:View It]][[Category:Reports]] | ||
Revision as of 16:09, 4 June 2019
Click here to watch a video on SmartSimple's integrated reporting subsystem.
In this article, you will build a report that lists all your contacts displaying their first name, last name, and title.
1. Click the Communications, Reports window.
The Reports window is displayed.
Note: If you have many custom fields, access the reports tab within the application you are creating the report from. If you are creating a report from a particular UTA, access the reports tab from that UTA.
2. Click the New Report tab.
The New Report window is displayed.
This window contains the following settings:
- Report ID - The unique ID assigned to the report. Will be a read-only field.
- Name - The name of the report will be displayed to users accessing the report.
- Category - The category you wish to associate with this report. Entering a unique category name will create a new entry in the Category combo box. Entering an existing category name will display this report in the existing category.
- Description - Narrative description of the purpose of the report.
- Lock - The "Do not rebuild report" checkbox indicates that the report should not be rebuilt in case of a custom Report Template, it will give an alert when the Report Builder button is clicked.
- Report Builder - This button opens the Report Builder.
- Recordsets - This tab is used to select which tables are required in the report, the relationships between the tables, and the primary table. The primary table determines how data will be joined when multiple tables are selected.
- Advanced - This tab shows advanced settings for the report. See this page for details on settings: Edit Report Page: Advanced Settings Tab
3. Set the Name to Contact List.
4. Set the Category to Training Reports.
This will create a new entry in the category combo box – Training Reports.
5. Set the Description to List Contacts - All.
6. Click the Save button.
The report is saved and the Delete and Preview buttons are displayed.
It will not be possible to preview this report, as you have not selected any table(s) nor selected any fields from the tables in the Report Builder.
Report Builder Neo
An enhanced version of the report builder has entered the beta stage. The new report builder allows for greater control of reports and features a more intuitive user interface.
- When creating a new report, a user now has the option of using the classic report builder or the new report builder.
Report Tabs
In addition to the Delete and Preview buttons, a new set of tabs are displayed at the top of the report window.
- Security – used to set the role permissions that will allow other users to access the completed reports.
- Sub-Reports – used to build a “nested” report.
- File Export – used for the default export settings for the report.
- Custom Export – used to create a custom export for the report.
- Report Template – used to control the layout and formatting of the report.
| @navbar@ |
| @header@ |
| @rows@ |
- Charts – used to create one or more charts to be associated with the report.
