Edit a Report

To learn more about this capability, click the Launch video button.

Reports allow you to view specific information for accounts, depending on the report generated. You can customize reports using the Report Output Builder. The default layout includes information such as Client Code, Client Name, Loss Type, Estimates, Issuing Company, Policy, and any dates associated with a claim.

Note: This article contains printing instructions that are only applicable if Applied Epic is installed locally on your computer. If you access Epic through a web browser such as Google Chrome, Mozilla Firefox, or Microsoft Edge, you cannot print directly from within the system. See Printing for more information about the printing capabilities available from Epic Browser. All other steps in this article are applicable to both methods of accessing Epic unless stated otherwise.

If you access Applied Epic using a web browser, you must install Layout Builder from Help > Connection Suite to add and edit layouts.

Access the Reports/Marketing area.
To access the Reports/Marketing area from the Home screen, do one of the following:
- Click Reports/Marketing on the navigation panel.
- Click Areas > Reports/Marketing on the menubar.
- Click the down arrow next to Home on the options bar and select Reports/Marketing.
To access Reports/Marketing from another area of the program, do one of the following:
- Click Home > Reports/Marketing on the menubar.
- Click the down arrow next to Home on the options bar and select Reports/Marketing.
The My Reports list defaults when the Reports/Marketing screen opens. If the report is in a different list, click the button for that list on the navigation panel, or click on My Reports in the view filter and make a different selection.

Click to highlight the existing report.
Do one of the following:
- Click the Edit button .
- Double click the report.
- Press [Ctrl]+O on your keyboard.
The Criteria screen displays. Click on a criterion to change specific items on the report. For example, click on Agency to select the agencies to be included/excluded in the report.
Click the Include Selections or Exclude Selections radio button to specify whether the items in the Selected list are to be included or excluded in the report.
The fields and/or lists on the right vary, depending on your criterion selection in the main list:
- Available and Selected lists
  
  Available items have no bearing on the report. Selected items are included or excluded in the report, depending on your Include Selections or Exclude Selections radio button selection.
  
  To move items between the two lists, click on the item you want to move and click the up arrow button or down arrow button .
  
  To move all of the items in the Available list to the Selected list, click the double down arrow button .
  
  To move all of the items in the Selected list to the Available list, click the double up arrow button .
- Dates
  Select one of the following radio buttons to specify which items to include in the report:
  - All dates: Include items from all dates (i.e. no filtering by date).
  - Blanks only: Include items with blank date fields (if no blank date fields exist, the report returns no information).
  - Fixed date range: Include items from the date range you specify.
  Enter a From date and a Through date, or select dates from the dropdown calendars. To leave either date open, select the corresponding Open checkbox.
  - Relative date range: Include items from a date range relative to the system date. When you run scheduled reports, they include items from the relative date range you define.
  Select the From system date and Through end of system date to define the range:
  Select the minus sign from the dropdown menu to include items from a range of days before and including the system date.
  The Sample Results Based on Date Selections section displays a summary of the items the report will include, based on your selections, if you run it today or one month from today.
- Months
  Select the appropriate radio button:
  - All: Run the report for all months.
  - Range: Enter a From month and year, or select a month and year from the dropdown menus. To leave the From date open, select the Open checkbox above the field.
  Enter a Through month or select a month and year from the dropdown calendar. To leave the Through date open, select the Open checkbox above the Through field.
  - Select month: The following choices are available in the dropdown menu:
  - - Current Default Month: The current month according to your computer.
    - Open through Current Default Month: A range of months from the date Applied Epic was first loaded through the current accounting month.
  Select the plus sign in the dropdown menu to run the report for the selected month plus a specific number of months.
  
  Select the minus sign in the dropdown menu to run the report for the selected month minus a specific number of months.
  
  Enter the number of Months. To run the report for the selected month only, leave the default entry of 0 Months.
- Radio button selections
  
  Select the radio button that applies to the highlighted criterion.
- Range of Account
  Select the appropriate radio button:
  - All: Run the report for all accounts.
  - Range(s): In the Range 1 row, enter at least one letter in the From field to indicate the letter with which the report should begin. Enter at least one letter in the Through field to indicate the letter with which the report should end. Repeat this procedure for additional ranges.
Each report includes a special criterion called Parameter Page. When you include it, the first page of the report lists all of the criteria you used to generate the report, so you can refer to them later. If you do not want a parameter page, select the Parameter Page criterion and click the Exclude Parameter Page radio button.
Include additional criteria if desired.
1. Click the Add button to the left of the list to open the Add Criteria window.
2. In the Available Criteria list, double click folders to open them and view the options they contain.
  
  Click Up one folder to return to the previous folder.
3. To select a criterion, click to highlight it in the Available list, and then do one of the following:
  - Click the right arrow button.
  - Double click the criterion.
4. Double click or use the arrow buttons to move items from one list to the other. When you are done, click Finish.
5. The new criteria display in the report's Criteria list. Set the criteria as described in step 7.
Optionally click Layouts on the navigation panel to change the report layout.

Click to highlight a layout in the list. Instead of using a saved layout, you can also opt to create a new layout or edit an existing layout. Once you are done creating or editing the layout, the Detail section allows you to changed the layout’s Name and/or Description for any language.

Note: To delete a layout in the list, click on the layout and click the Delete button. You are prompted, "Do you wish to delete this record? Click Yes.

Click Delivery Options on the navigation panel.

Specify where (or to whom) the report is to be sent. Current User, meaning the person who is running the report, is a report recipient automatically. You can do the following here:
- Add a Recipient
  1. Do one of the following:
    - Click the Add button .
    - Press [Insert] on your keyboard.
  2. To choose a recipient, click the lookup button to the right of the Recipient field.
  In the Who to Contact pop-up window, select an Account Type, enter at least the first letter of the Lookup code, and click Locate or press [Enter]. Click on the correct account and then click Finish.
  1. If Multilingual Reports is enabled in Regional Settings Configuration, you may change the Language in which to send the report if necessary. The <Recipient’s preferred language> defaults.
    
    Note: If a layout does not exist for the Language you select, a message displays, warning you that the report will not be delivered to the recipient and asking if you wish to continue.
  2. Choose the Printer, Email, and/or Fax # to which to send the report.
  3. If you send the report to an email address, choose the report format in the Attach as dropdown menu:
  1. - CSV
    - Microsoft Excel Workbook
    - PDF
  Note: The Excel workbook option is included to allow you to extract the raw data and use the options available in Microsoft Excel to work with the data. Each row that was visible in the PDF version is visible in the Excel workbook. The main difference between the two is the layout. The advantage of the Excel workbook over the PDF version is that it allows you to sort the data using columns. For example, you can sort alphabetically by Account Name by using the sort filter in Excel. This option also allows you to format the data any way you like.
  
  The report in Excel includes all the raw data needed to create the report, including items that do not display on the printed output (such as data items that are in some conditional detail sections but not in others). It does not include any totals or calculations created from the raw data.
  1. If you do not want your report to print, highlight the printer in the Printer field and press [Delete] on your keyboard.
  2. The Marketing Distribution Log documents all delivery attempts for a marketing campaign, both successful and failed. You can review recipients’ contact information on the report to help you address any issues.
    To generate this log, select the Receive copy of Marketing Distribution Log checkbox and select a delivery option from the Via dropdown menu. Only options that correspond to the delivery options you have selected for the chosen recipient are available for selection from the Via menu.
  3. Click Finish to save the changes.
  Click Add to add another report recipient.
  
  Click Cancel to close the window without adding the recipient.
- Edit Recipient Information
  1. Click on the name of the recipient whose information you want to change.
  2. Do one of the following:
    - Click the Edit button .
    - Double click the recipient name.
  3. If you are changing your own delivery options (Current User) and you should be notified only under certain circumstances or not notified at all, click the Change Notification Settings link label.
    1. In the Change Notification Settings pop-up window, select the appropriate radio button and click Finish.
      
      Successful: Notifies the recipient if the report reached all recipients.
      
      Unsuccessful: Notifies the recipient if the report did not reach an intended recipient.
      
      No notification: This recipient receives no notification of the success or failure of the report delivery.
      
      Note: The notification defaults are set in Notifications Configuration. You must have security rights granted in order to change this selection.
    2. Select the Notify Only checkbox if you do not need a copy of the report but should be notified of its delivery status (successful or unsuccessful). This disables the Printer, Email, and Fax # dropdown menus.
  4. If Multilingual Reports is enabled in Regional Settings Configuration, you may change the Language in which to send the report if necessary. The <Recipient’s preferred language> defaults.
    
    Note: If a layout does not exist for the Language you select, a message displays, warning you that the report will not be delivered to the recipient and asking if you wish to continue.
  5. If you did not select the Notify Only checkbox, choose the Printer, Email, and/or Fax # to which to send the report.
  6. If you send the report to an email address, choose the report format in the Attach as dropdown menu:
    - CSV
    - Microsoft Excel Workbook
    - PDF
  Note: The Excel workbook option is included to allow you to extract the raw data and use the options available in Microsoft Excel to work with the data. Each row that was visible in the PDF version is visible in the Excel workbook. The main difference between the two is the layout. The advantage of the Excel workbook over the PDF version is that it allows you to sort the data using columns. For example, you can sort alphabetically by Account Name by using the sort filter in Excel. This option also allows you to format the data any way you like.
  
  The report in Excel includes all the raw data needed to create the report, including items that do not display on the printed output (such as data items that are in some conditional detail sections but not in others). It does not include any totals or calculations created from the raw data.
  1. To save an electronic copy of the report, select the Save to Disk checkbox and select a document type in the Save as dropdown menu. Click the lookup button to the right of the Location field and browse to the desired folder.
    
    Note: This option is available only if you are editing the Current User settings.
  2. The Marketing Distribution Log documents all delivery attempts for a marketing campaign, both successful and failed. You can review recipients’ contact information on the report to help you address any issues.
    
    To generate this log, select the Receive copy of Marketing Distribution Log checkbox and select a delivery option from the Via dropdown menu. Only options that correspond to the delivery options you have selected for the chosen recipient are available for selection from the Via menu.
  3. Click Finish to save the changes.
  Click Cancel to close the window without saving any changes to the recipient information.
- Delete a Recipient
  1. In the list, click on the recipient that you want to remove.
  2. Click the Delete button .

You can also save an electronic copy of the report.

If any recipients are to receive the report via email or fax, enter a Subject and Message for the fax and/or email in the Email/Fax Detail section.

Note: The Subject field is required.

If any recipients will receive the report via email, select a From email address. See Distribution Email Accounts for instructions on adding email addresses to this list.
If any recipients will receive the report via fax, select a Cover page in the dropdown menu. To change the Language of the selected Cover page, select it from the Language dropdown menu.

Note: You must set up a Cover page in all desired languages in Fax Cover Page Configuration to make these languages available for selection from this dropdown menu.

To change the name that prints on the fax as the sender, click the Change Sender link label. In the Change Sender pop-up, select a Name from the dropdown menu. Optionally add a Fax number with Ext, Phone number with Ext, and Email address to print on the fax. Click Finish.

Note: Some reports filter based on each user's structure access. That means that if a report has two recipients, the final report that each recipient receives might differ, since they may have different structure access. It does not matter who initially created the report, whether it is in My Reports or Report Quick View, etc. Click here for a list of reports that filter based on structure.
- Activity
- - Activity Commission Report
  - Activity Declination Report
  - Activity Exceptions
  - Activity Report
  - Activity Summary Analysis
- Application
- Personal Auto
- Residential Homeowners
- Claim
- - Claim Report
- General Ledger
- - Bank Reconciliation Detail
  - Bank Reconciliation Worksheet
  - General Ledger Register
  - General Ledger Schedules Report
  - Status of Accounts
  - Voucher Report
- On Demand
- - Employee Workload Report
  - GL Opening Balance Report
  - Workload Reassignment
  - Preview Workload Reassignment
- Policy
- Binder Report
- Book of Business – Line Book
- Book of Business – Policy Book
- Expiry Report
- Policies With No Transactions
- Policy List Report
- With This, Not That Transaction
- Account Current Report
- Aged Current Premium Payables
- Aged Outstanding Current Balances Report
- Aged Producer/Broker Payables
- Balancing Aged Producer/Broker Payables
- Balancing Binder Payables
- Balancing Current Premium Payables
- Balancing Current Receivables
- Balancing Deferred Income
- Balancing Deferred Transaction Interagency Payables/Receivables
- Balancing Government Payables
- Balancing Producer/Broker Payables
- Billing Register
- Broker Commission
- Deferred Payables – Broker
- Deferred Payables – Producer
- Direct Bill Report
- Earned Commissions
- Government Payables Report
- Miscellaneous Production Report
- Premium Payables
- Producer/Broker Payables
- Producer Commission Report
- Production Report
- Transaction Generated Payments Report
- Transaction Interagency Payables/Receivables
- Transaction Reconciliation – Government Payables
- Transaction Reconciliation Discrepancy – Premium Payables
- Transaction Reconciliation Discrepancy – Producer/Broker Payables
- Transaction Reconciliation Report
- Unapplied Cash/Credit Report
- Write-Off Report
When you use Marketing Preview, the report displays each record according to the criteria set and limits results by the structure access granted to the current user.

In the Scheduling section, opt to run the report Now, or Schedule it to run later.

If you choose Schedule, enter a date (or choose a date from the dropdown calendar) and time for the report to run. Select a Recurrence option:

- One Time Only
- Every Weekday (M-F)
- Daily
- Weekly
- Monthly
- Quarterly
- First Day of the Month
- Last Day of the Month

If you choose anything but One Time Only, the report runs automatically at the chosen interval at the time indicated in this section. Consider setting up lengthier reports to run after business hours.

Marketing options are available for some reports. If you intend to generate letters, use an email template, add activities to accounts, or send text messages based on the report results, you must set up a new email template, letter template, activity category, and/or SMS message template before configuring marketing options. The templates are used for the emails, letters, or text messages sent through the campaign; the activity category helps you track the campaign's effectiveness.
- Account Reports
- Applications
- Policy
1. If you plan to launch a marketing campaign based on information from this report, choose the appropriate checkbox(es) in the Marketing Options section:
  - Generate Letter: Generate a letter for each account that displays in the report.
    Click the lookup button to open the Available Templates window.
    
    Select a Template Folder from the dropdown if necessary.
    
    Select a template from the list.
    
    The Distribution method defaults as the method configured in the selected template, but you can select a different one from the dropdown if necessary. Each method has different options:
    
    Generate as email
    
    Select an Insert into email as option. You can select the Attach email to account checkbox to save the email as an attachment on the recipients' accounts.
    
    Select a From email address.
    
    Enter an email Subject, or use the lookup button to select a variable from the Available Description Variables pop-up window.
    
    Enter a Message if necessary. This message will display to all email recipients.
    
    Generate as fax
    
    Enter a fax Subject manually, or use the lookup button to select a variable from the Available Description Variables pop-up window.
    
    Enter a Message if necessary. This message will display to all fax recipients.
    
    Generate as mail
    
    If necessary, select a Paper type from the dropdown menu.
    
    Use preferred contact method
    
    The Use preferred contact method option only displays for templates configured to use it as its Distribution method with Marketing as its letter type. Select this option to distribute the report based on each contact’s Marketing dropdown menu selection in the Preferred Contact Method frame of Contact detail.
    
    The letter type defaults based on the selected template. Although you can select another letter type on the dropdown menu, it is not recommended, as it may cause errors.
    
    Select a paper type from the dropdown menu if necessary.
    
    Select an Insert into email as option. You can select the Attach email to account checkbox to save the email as an attachment on the recipients’ accounts.
    
    Select a From email address.
    
    Enter an email Subject, or use the lookup button to select a variable from the Available Description Variables pop-up window.
    
    Enter a Message if necessary. This message will display to all email recipients.
    
    Click Finish.
    
    To attach a copy of the letter to each account for which the letter is generated, select the Attach copy to account checkbox.
  - Send email template: Use an email template to send a mass email based on your report criteria. Before sending the email, you may want to add the Record Listing criterion to your report from the Modify Criteria screen to ensure that the report does not send duplicate emails. For example, the Policy List report might send multiple emails to a contact with multiple policies that meet your criteria.
    
    Many account and policy-related reports have a Record Listing criterion available on the Modify Criteria screen. You can use it to control the number of records that match your criteria that are included in the report. The specific options available vary, depending on the report selected. This option is useful for sending a mass email using a report, because you can control whether an email is sent for each record that matches your criteria or only once per account.
    Click the lookup button to open the Select Email Template pop-up window.
    
    The From field defaults based on your selection in the Email/Fax Options frame on the Delivery Options screen, but you can click the Change Sender link label to select a different option if necessary.
    
    Select a Template from the dropdown.
    
    The Branding profile and Signature default based on your template selection, but you can choose a different branding profile and signature if necessary.
    
    The Subject line defaults based on your template selection, but you can edit it if necessary.
    
    The Message defaults based on your template selection, but you can edit it if necessary. Use the formatting ribbon to apply styling.
    Note: If the message contains merge variables, they do not populate with client/prospect information in the preview. The variables will populate with each email recipient’s information when you run the report.
    
    If you make changes to the Message and want to revert to the original Template, Branding, or Signature, click the Refresh link label beside the option you want to reset.
    
    Click Finish to save your changes and close the Select Email Template pop-up window.
    Click Cancel to discard your selections without saving.
  - Add Activity: Add an activity for each account that displays in the report.
    Click the lookup button to open the Activity Lookup window.
    
    Narrow the activities that display if necessary.
    
    Use the search bar above the list to specify the activities that you want to see.
    
    These are the choices in the first dropdown menu:
    
    Code
    
    Description
    
    Category
    
    The choices available in the second dropdown menu vary, depending on the selection you made in the first dropdown.
    
    Equals: Enter the search criterion (e.g., the full description or folder name) in the field to the right, or select the correct date from the dropdown calendar (if applicable). Click Find.
    
    Contains: Enter at least one character of the search criterion (e.g., part of the description or claim number) in the field to the right. Click Find.
    
    You can apply multiple filters if necessary.
    
    To apply multiple filters to the list, do one of the following:
    
    Click the Edit Filter button .
    
    Press [Ctrl] + E.
    
    The Edit Filter pop-up window displays.
    
    Note: You can also use the Edit Filter button, rather than the search bar, to apply a single filter to the list if you prefer.
    
    Select and/or enter your desired search criteria using the dropdown menus and fields, and then click the Add button. The Name, Compare Type, and Criteria for your filter display in the list. Click one of these column headings to sort the list by that column. To reverse the sort order, click the column heading again.
    
    To apply additional filters, enter additional search criteria and continue clicking Add. To remove a filter from the list, select it and click the Delete button.
    
    Click Finish when you have applied all of your desired filters.
    
    To exit the dialog without applying any filters, click Cancel.
    
    Select the activity code.
    
    The settings for the selected activity code default in the Activity Options section. Enter or revise the options as needed.
    
    Select the Owner Type. If you select Specific Person or Specific Work Group, choose the corresponding person or work group in the Specific owner dropdown menu.
    
    Select a radio button to Default activity as Open or Closed.
    
    If you choose Closed, you can select Successful or Unsuccessful in the Closed dropdown menu.
    
    Optionally enter an Activity note.
    
    Click Finish.
  - Add Sticky Note
    Click the lookup button to open the Sticky Note Options window.
    
    Optionally select a different sticky note Color.
    
    Optionally select a different sticky note Priority.
    
    Enter text in the Sticky note box.
    
    Select the Expiry date checkbox if the sticky note should expire.
    
    If you select the checkbox, select a date in the dropdown calendar.
  - Send SMS (enabled only for reports used to market to clients)
    A template is required to send marketing SMS messages. See SMS Template Configuration for instructions on adding templates.
    
    Click the lookup button . The Select SMS Template pop-up window displays.
    
    Select a Template. To filter the Template list, choose a Tag.
    
    Your template selection determines the text that displays in the message. You cannot edit this text.
    
    Click Finish.
1. Select the Preview/Edit results before processing checkbox if you want to market only to some of the clients who meet the selected criteria. Previewing the results is recommended you are sending SMS messages for this campaign, as you will be charged for each message sent. If you select this checkbox, you will need to launch the marketing campaign from the Marketing area after you generate the report.
  
  Note: The preview option is not available if the campaign is scheduled (step 20).
2. Select the Include "Do Not Market" checkbox if applicable.
3. If you selected the Generate Letter, Add activity, Add sticky note, or Send SMS checkbox(es) in Marketing Options, you can select a Marketing Distribution Contact for all marketing campaign-enabled reports (except the Contact List and Employee List reports):
Please note that your selected Marketing Option(s) behave differently if you select a Contact Classification in the Marketing Distribution Contact frame:

Do one of the following:
- Click Actions > Generate Report on the options bar.
- Click Actions > Generate Report on the menubar.

If you opted to launch a marketing campaign in step 18, you may or may not need to take an additional action:

- If you did not select the Preview/Edit results before processing option in step 18, your marketing campaign launches now.
- If you did select the Preview/Edit results before processing option in step 18, you must launch the marketing campaign from the Marketing area in order to generate the appropriate letters, activities, etc.

When you exit the screen, you are prompted, "Do you want to save changes?"

Click Yes to save the changes you made to the report.

Click No if you do not want to save the changes you made to the report.

Click Cancel to remain on the Delivery Options screen.