Difference between revisions of "Creating a Basic Report"
| Line 26: | Line 26: | ||
* '''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. | * '''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: | * '''Advanced''' - This tab shows advanced settings for the report: | ||
| − | ** '''Criteria Text''' - Text used to prompt the [[User|user]] when they are [[Prompting for Criteria in Reports|required to enter]] some [[criteria]] values. | + | ** '''Criteria Text''' - Text used to prompt the [[User|user]] when they are [[Prompting for Criteria in Reports|required to enter]] some [[:Category:Criteria|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'''. | ** '''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 Reports|Internet Enabled]]''' - Displays a [[URL]] that allows the report to be [[Creating a Public – Internet Enabled Report|accessed over the internet]] without the need for a [[User|user]] to log into the system. This setting is useful for creating public reports. | ** '''[[Internet Enabled Reports|Internet Enabled]]''' - Displays a [[URL]] that allows the report to be [[Creating a Public – Internet Enabled Report|accessed over the internet]] without the need for a [[User|user]] to log into the system. This setting is useful for creating public reports. | ||
Revision as of 08:12, 30 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.
- 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:
- 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 accessed over the internet without the need for a user to log into the system. This setting 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.
- 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.
