|
|
(15 intermediate revisions by 5 users not shown) |
Line 1: |
Line 1: |
− | {{SeqReportPageHeader}}
| + | #REDIRECT [[Reports#Creating a Basic Report]] |
− | | |
− | '''[http://www.smartsimple.com/DotOrg/flash/Creating_a_basic_Report_viewlet_swf.html 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.
| |
− | | |
− | [[Image:Repor.png]]
| |
− |
| |
− | 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.
| |
− | * '''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|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'''.
| |
− | | |
− | [[Image:Repor2.png]] | |
− |
| |
− | 4. Set the '''Category''' to '''Training Reports'''.
| |
− | | |
− | [[Image:Repor3.png]]
| |
− |
| |
− | This will create a new entry in the category combo box – '''Training Reports'''.
| |
− | | |
− | [[Image:Repor4.png]]
| |
− |
| |
− | 5. Set the '''Description''' to '''List Contacts - All'''.
| |
− | | |
− | [[Image:Repor5.png]]
| |
− |
| |
− | 6. Click the '''Save''' button.
| |
− | | |
− | The report is saved and the '''Delete''' and '''Preview''' buttons are displayed.
| |
− | | |
− | [[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'''.
| |
− | | |
− | =Report Tabs=
| |
− | | |
− | In addition to the '''Delete''' and '''Preview''' buttons, a new set of tabs are displayed at the top of the report window.
| |
− | | |
− | [[Image:Reps4.png]]
| |
− |
| |
− | * '''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|role]] permissions that will allow other [[User|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.
| |
− | <pre>
| |
− | <html>
| |
− | <body>
| |
− | <table>
| |
− | | |
− | <tr><td>@navbar@</td></tr>
| |
− | <tr><td>@header@</td></tr>
| |
− | <tr><td>@rows@</td></tr>
| |
− | | |
− | </table>
| |
− | </body>
| |
− | </html>
| |
− | </pre>
| |
− | * '''Charts''' – used to create one or more charts to be associated with the report.
| |
− | | |
− | {{PrevNextStart}} [[Accessing Reports in SmartSimple]]
| |
− | {{PrevNextMid}} [[Adding a Table to a Report]]
| |
− | {{PrevNextEnd}}
| |
− | | |
− | | |
− | [[Category:View It]][[Category:Reports]]
| |