reports.xml file provides a definition of the column heading, report filter, report file and the Sql query. It also provides some other configuration information such as whether this report should be available across all the groups in OfficeClip or only to a specific number of groups.

This file is copied and modified from the file c:\program files\officeclip\7\officeclip\APP_DATA\reports\customReports.xml

1. Navigate to the file c:\program files\officeclip\7\officeclip\custom\API\walkthru3\customReport.xml.
   
   
2. This file contains the following:

                                                           
     <report id="10022" path="custom/API/Walkthru3/" name="MemberR.rpt"
                   program="te/expense/reports/custom/none.aspx"
                   dataset="temp" category="customExpense" subcategory="Expense Report - Custom">
       <title>
         Member List
       </title>
       <description>
         Gets a list of OfficeClip members.
       </description>
       <col1>Name</col1>
       <col2>Email</col2>
       <GroupPermission value="-1" />
       <sql>
         <![CDATA[
         select (u.first_name + ' ' + u.last_name) AS Name,
         u.email_address as Email
         FROM users u, usergroups ug
         WHERE u.user_id = ug.user_id
         AND u.active = 'Y'
         AND is_external = 0
         AND ug.group_id = :groupId
        ]]>
       </sql>
     </report>