Creating a custom Word or Excel report

For complete instructions, select Custom Reports on the Reports tab to bring up the Custom Reporting User Guide. Or view it online at Also, be sure to check out the custom reporting video series. Read on for a quick overview.

It's easiest to start with an existing report template that resembles the custom report that you have in mind:

  1. Click the Word button on the Reports tab (or select  Tools/Generate Word Report if using 2010 R2 or earlier)
  2. Select the report you would like to base a new report off of (single click on the report name)
  3. Click the Edit Template Button
  4. This will open the report template in Word.  The template is read-only so that you don't overwrite the built-in template, so the first thing you should do is save the report to a new folder of your choice (Select File/Save As in Word).  Please choose a folder other than Program Files since that folder may be removed when you upgrade.
  5. Edit the report template and save your changes

To generate your custom report, select Reports from another folder in the report generation dialog and browse to the folder that you saved your custom report to in step 4 above.  Then generate the report as you normally would.

Have more questions? Submit a request
Was this article helpful?
0 out of 0 found this helpful


  • Avatar
    Steve Pullan

    Is there a list of all the macros/properties usable within the templates?  (e.g. where is $listOpenIssues or $tableOpenIssuesSortParentID defined and what alternatives are there?)

  • Avatar
    Doug Earl

    Hi Steve, yes absolutely.  You can get that by selecting Help / Custom Reports in CaseComplete.

  • Avatar
    Steve Pullan

    Oops!   Should have looked there first ;-)  Thanks

Powered by Zendesk