Report Writer

The Report Writer is used to create new reports or to modify existing editable reports. The Report Writer guides you through a series of dialogs in which you name your and describe your report, select the modules that contain the data you want to report against, and choose the report criteria.

Naming the Report and Selecting Modules

1. Click Reports in the Quick Links section. The Reports screen displays.

2. Click New Report. The Create New Report dialog displays.

3. Enter in the name and description of the report. The report name can contain letters and numbers. Do not use special characters such as quote marks.

4. Select the module which contains the primary data of your report.

5. Select related modules. This may include additional data associated with each record. For example, if you are building a forecast report, the primary data for opportunities is in the Sales module. But you can add names, company information, or custom fields from the related modules. Hold the CTRL key and click multiple related modules.

6. Click Next.

Selecting Report Type

Select Tabular or Summary as desired. Summary will provide subtotals by groupings.

Selecting Report Fields

1. Click the Fields tab. The Fields page displays.
2. Click the desired report fields in the Available Fields column while holding the CTRL key down.
3. When all desired fields have been selected, click Add. These fields will be in your report. You may edit this at any time using Add and Remove.
4. To rearrange the order of appearance, select a field and use Up or Down buttons. The order will appear left to right on the final report.

Selecting Fields to Total

Note: The Fields to Total tab does not appear if you selected Tabular report type. Make sure your report type is set to Summary if calculations are needed in the report. Numeric fields from your selection will be available for totals and subtotals.

1. Click the Fields to Total tab. The Fields to Total page displays.
2. Check off the type of calculation preferred.

Using Field Alias

Field Aliases are custom column headings. You may rename any or all fields in the report. However field aliases are not currently supported for fields that have been selected as group headers.

1. Click the Field Alias tab. The Field Alias page displays.
2. Enter a new label for any field desired (i.e. Entity Name = Company Name).

Entering Report Criteria

1. This is the most important part of building an accurate report
2. Select the Record type of the first criteria item. This refers to the table that data resides. Example: City or State would be in the Entity table where the account address and other company information resides, Projected Close Date would be in the Opportunity module
3. Now select the Field
4. Select the Condition
5. Enter the criteria

This row selects Opportunities that have a probability of greater than 50%. Add additional rows for very specific and valuable business reports. For “floating” days where the report always contains the “Next 60 Days” from today, use the ‘Period’ field as shown on the second row below, with any combination of ‘Less Than’ or ‘Greater Than’ as a conditions (use multiple rows for less than 90 greater than 60, e.g.). Use ‘Next xx days’ as criteria format. (30, 60, 90)

3. To Create a New Report, click the ‘New Report’ button

4. You may begin building your own search and selection criteria, very similar to creating a Saved Search.

5. Select a Module which is the table of primary infor-mation in your report (Sales = forecast data. Activity = activity, etc.) then select as many related modules as appropriate by holding CTRL + click each module. These are the fields of data that will be available. Follow along each tab and build your report

6. Use ‘Criteria’ to build the conditions as to which infor-mation will appear in the report. Add as many rows as needed

Errors

In the event your report has errors or shows a blank page, it is likely that you have not selected data from the proper module(s). Check the settings in your report and be sure you have selected the proper modules and respective fields.

Return to Reports