Reports display information in tabular form and allow selection of fields, groups and filters. Results can also be saved or exported in various formats such as Adobe PDF (.pdf), Microsoft Word (.doc) and Microsoft Excel (.xls).
Click on the application where you want to create a new report, and then click
and . Follow the steps in the wizard to setup the new report:Select the Report Category where you are generating the report, whether it is in Contacts, Accounts, Opportunities, etc.
Select the Report Type. Report types are templates for which reports are already created. This allows you to pick and choose a pre-defined report and modify it.
Give an appropriate Name to the report.
Fill in the Report Description. This field is shown on the list screen and allows users to quickly find the report they need.
Add a Report Header if needed. The Report Header shows up at the top of every page of the report.
The Report Footer shows at the bottom of every page of the report. You can also add page numbers if needed.
Report Print Layout allows you to select the kind of page to which the report prints.
Fields are columns in the report. This user interface allows selection of the fields in various entities to be displayed on the report.
![]() | Warning |
---|---|
If the number of fields selected is more than the page size permits, the additional fields will run over to the next page. |
Some of the field names that are selected in the previous step
may not be friendly (for example, pre-defined field names could be
Contact.Address1
, Contact.City
etc., instead of just Address1
and
City
). This step allows the user to rename these
fields.
Groupings can be created for various columns in the report. For example, the total number of hours and count of the users are groups. Group totals can also be put at the bottom of the groups.
Filters allow selection of a range of values based on given criteria. Various types of filters are supported for OfficeClip reports and vary by the category and type of the report. For example, reports can be filtered by date range, users, status, etc.
To see how to create filters, click .
Sometimes it is necessary to restrict filters for a group of users. For example, you may not want to allow your users to change the customer of a timesheet report but it is okay if they change the date range. This option allows users to restrict certain filters to non-administrators and extranet users.