Difference between revisions of "Creating a Basic Report"
From SmartWiki
(→Report Tabs: - updating for new features) |
(updating for new features) |
||
| Line 19: | Line 19: | ||
This window contains the following settings: | This window contains the following settings: | ||
| − | * ''' | + | * '''Name''' - The name of the report will be displayed to [[User|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. |
| − | * '''View''' - Determines if the report should show the information in a list – '''List View''', or one record at a time – '''Single Record View'''. | + | * '''Description''' - Narrative description of the purpose of the report. |
| − | * '''Internet Enabled''' - Displays a [[URL]] that allows the report to be displayed accessed over the internet without the need for a [[User|user]] to log into the system. This type of report is useful for creating public reports. | + | * '''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. |
| − | + | * '''Recordsets''' - This section 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: | |
| − | + | ** '''Criteria Text''' - Text used to prompt the [[User|user]] when they are required to enter some criteria values. | |
| + | ** '''View''' - Determines if the report should show the information in a list – '''List View''', or one record at a time – '''Single Record View'''. | ||
| + | ** '''Internet Enabled''' - Displays a [[URL]] that allows the report to be displayed accessed over the internet without the need for a [[User|user]] to log into the system. This type of report is useful for creating public reports. | ||
| + | |||
3. Set the '''Name''' to '''Contact List'''. | 3. Set the '''Name''' to '''Contact List'''. | ||
| Line 31: | Line 34: | ||
[[Image:Repor2.png]] | [[Image:Repor2.png]] | ||
| − | 4. Set the ''' | + | 4. Set the '''Category''' to '''Training Reports'''. |
[[Image:Repor3.png]] | [[Image:Repor3.png]] | ||
| − | This will create a new entry in the | + | This will create a new entry in the category combo box – '''Training Reports'''. |
[[Image:Repor4.png]] | [[Image:Repor4.png]] | ||
Revision as of 05:40, 29 April 2013
Click here to watch a video on SmartSimple's integrated reporting subsystem.
View It Here
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, View 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:
- 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.
- Recordsets - This section 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:
- Criteria Text - Text used to prompt the user when they are required to enter some criteria values.
- View - Determines if the report should show the information in a list – List View, or one record at a time – Single Record View.
- Internet Enabled - Displays a URL that allows the report to be displayed accessed over the internet without the need for a user to log into the system. This type of report is useful for creating public reports.
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 Tabs
In addition to the Delete and Preview buttons, a new set of tabs are displayed at the top of the report window.
- Recordsets – displays the window used to select recordsets used in the report.
- Advanced – displays further settings for the report.
- 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.
<html> <body> <table> <tr><td>@navbar@</td></tr> <tr><td>@header@</td></tr> <tr><td>@rows@</td></tr> </table> </body> </html>
- Charts – used to create one or more charts to be associated with the report.
