Difference between revisions of "Adding Fields to a Report"
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | {{SeqReportPageHeader}} | ||
| + | |||
First you will add the fields you need to the '''Report Builder'''. | First you will add the fields you need to the '''Report Builder'''. | ||
| Line 9: | Line 11: | ||
* On this instance, [[Custom Fields|custom fields]] associated with any [[Role|roles]] that you have created will be displayed as the [[Role|roles]] may also be associated with the contact. | * On this instance, [[Custom Fields|custom fields]] associated with any [[Role|roles]] that you have created will be displayed as the [[Role|roles]] may also be associated with the contact. | ||
| − | This display of [[Role|role]] based fields when accessing the contact table is an example of the internal denormalization of the contact table. | + | This display of [[Role|role]] based fields when accessing the contact table is an example of the internal [http://en.wikipedia.org/wiki/Denormalization denormalization] of the contact table. |
2. Choose the '''First name''' field. | 2. Choose the '''First name''' field. | ||
| Line 29: | Line 31: | ||
[[Image:Resp14.png]] | [[Image:Resp14.png]] | ||
| − | 6. Click the '''Build Query''' button. | + | 6. Click the '''Build Query''' button. {{BuildQueryButton}} |
The settings are saved, the '''Report Builder''' window is closed, and you are returned to the '''Edit Report''' window. You can now '''Save''' and '''Preview''' the current report. | The settings are saved, the '''Report Builder''' window is closed, and you are returned to the '''Edit Report''' window. You can now '''Save''' and '''Preview''' the current report. | ||
| Line 53: | Line 55: | ||
10. Close the '''Parameter''' window. | 10. Close the '''Parameter''' window. | ||
| + | |||
| + | {{PrevNextStart}} [[Report Builder Column Settings]] | ||
| + | {{PrevNextMid}} [[Changing the Column Display Order in a Report]] {{PrevNextEnd}} | ||
| + | |||
[[Category:Reports]] | [[Category:Reports]] | ||
Latest revision as of 12:10, 30 August 2013
Click here to watch a video on SmartSimple's integrated reporting subsystem.
First you will add the fields you need to the Report Builder.
1. Click the Field combo box for the first column.
- All the fields from the selected table(s) – in this case the single table – the fields in the contact table are displayed.
- In addition, to the standard fields, any custom fields that you have added to this table are also displayed, and are available for use in the report.
- On this instance, custom fields associated with any roles that you have created will be displayed as the roles may also be associated with the contact.
This display of role based fields when accessing the contact table is an example of the internal denormalization of the contact table.
2. Choose the First name field.
The field name is added and the column heading set to the field name.
3. Change the column heading to First Name.
4. Repeat this process for the Last name, Title and Company Name fields.
5. Change the column heading as shown below.
6. Click the Build Query button. 
The settings are saved, the Report Builder window is closed, and you are returned to the Edit Report window. You can now Save and Preview the current report.
7. Click the Save button.
The report is saved with the new setting you have added.
8. Click the Preview button.
You are prompted to set any parameters – there are no parameters. The prompt for parameters will not be displayed when you access the report from the report list.
The report is displayed in a separate window.
The data is displayed in the original entered by sequence, as there is not sorting applied
- You can sort by any column in this view by clicking on the required column heading.
- The column headings are set to the values you set.
- The standard SmartSimple multi-page navigation has been added to the report and the report is displayed with the Number of Records per Page as set in your Personal Settings.
9. Close the Report window.
10. Close the Parameter window.
