Difference between revisions of "Creating a Basic Report"

From SmartWiki
Jump to: navigation, search
 
Line 1: Line 1:
 
'''[http://smartsimple.com/files/113/f102251/Creating_a_basic_Report_viewlet_swf.html View It Here]'''
 
'''[http://smartsimple.com/files/113/f102251/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.
 +
 +
2. Click the '''New Report''' tab.
 +
 +
The New Report window is displayed.
 +
 +
[[Image:Repor.png]]
 +
 +
This window contains the following settings:
 +
 +
'''Report Name''' - The name of the report will be displayed to [[User|users]] accessing the report.
 +
'''Tab Name''' - The tab you wish to associate with this report.  Entering a unique tab name will create a new entry in the '''Report Type''' combo box.  Entering an existing tab name will display this report in the existing tab.
 +
'''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.
 +
'''Report Description''' - Narrative description of the purpose of the report.
 +
'''Criteria Description''' - Text used to prompt the [[User|user]] when they are required to enter some criteria values.
 +
'''Report Tables'''- 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. 
 +
 +
3. Set the '''Name''' to '''Contact List'''.
 +
 +
[[Image:Repor2.png]]
 +
 +
4. Set the '''Tab''' to '''Training Reports'''.
 +
 +
[[Image:Repor3.png]]
 +
 +
This will create a new entry in the '''Report 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'''.
 +
 +
 +
  
 
[[Category:System Management]][[Category:View It]][[Category:Reports]]
 
[[Category:System Management]][[Category:View It]][[Category:Reports]]

Revision as of 13:06, 19 October 2007

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.

2. Click the New Report tab.

The New Report window is displayed.

Repor.png

This window contains the following settings:

Report Name - The name of the report will be displayed to users accessing the report. Tab Name - The tab you wish to associate with this report. Entering a unique tab name will create a new entry in the Report Type combo box. Entering an existing tab name will display this report in the existing tab. 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. Report Description - Narrative description of the purpose of the report. Criteria Description - Text used to prompt the user when they are required to enter some criteria values. Report Tables- 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.

3. Set the Name to Contact List.

Repor2.png

4. Set the Tab to Training Reports.

Repor3.png

This will create a new entry in the Report Combo BoxTraining Reports.

Repor4.png

5. Set the Description to List Contacts - All.

Repor5.png

6. Click the Save button.

The report is saved and the Delete and Preview buttons are displayed.

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.