Creating a CommGen Report Definition

Overview

Once a data source and Microsoft Word template are created for your communication, you need to link them together via the Report Definition page.

Navigation

Reporting Tools > BI Publisher > Create BIP Report Definition

Step-by-Step Process

  1. Click the Add a New Value tab.
  2. Enter the Report Name.

    Screenshot of the Report Definition page showing the report name, data source type and data source id fields

    • Report Names should follow this standard convention: M__. For example, MRA_OUA_AVE, MRA_RAC_CAM, MRA_BUS_DOU
    • Functional Areas for Student Administration include:
      • RA = Recruiting and Admissions
      • FA = Financial Aid
      • SR = Student Records
      • SF = Student Financials
      • HE = Cross Student Administration
  3. Select XMLDoc Object from the Data Source Type drop-down list. DO NOT allow the default value of Query to remain in this field.
  4. Select your data source in the Data Source ID field.
    • The Data Source ID cannot be changed after the record is saved. Always verify you have selected the correct Data Source ID.
  5. Click Add.

Definition Tab

Screenshot of the Definition tab showing report description, report status, report category id, owner id and template type fields

  1. Enter a Report Description that functionally describes the communication you are defining with this report.
  2. Select Active from the Report Status menu.
  3. Look up or enter the code that relates to your office in the Report Category ID field.
  4. Select the Owner ID from the drop-down list if it does not populate automatically.
  5. Ensure the Template Type is RTF.

Template Tab

Screenshot of the Template tab showing description, channel, and status fields, and the upload and preview buttons

  1. Enter the Description. This should match the Report Description entered on the Definition tab.
  2. Select the communication delivery method from the Channel menu. When producing letters, select Printer. When producing emails, select Email.
    • Although an email and letter cannot be produced during the same CommGen run, both an email template and letter template can be set up under the same Report Definition. This is done by adding multiple template IDs with different channel values. This may be useful for high priority communications that must be delivered even in the event of a bounced email.
  3. Select Active from the Status drop-down list.
  4. Click Upload.
  5. Navigate to and select your Microsoft Word BI Template.
  6. Click Preview to view the communication.

Notes:

  • You can set up more than one template for a communication. This is useful when you need to have both an email and printed version of a communication. After completing all fields on the Template tab for the first Template ID, click the Add a Row button in the Template section of the page and complete the fields for the second template. You must set one of the templates as the default for the communication by checking the Default Template box on the appropriate template.

    Screenshot of the Template tab showing the add a row button and default template field

  • DO NOT delete or inactivate a template once it has been used. Doing so will eliminate the ability for students and staff to view prior communication content.
  • If changes are made to a template and a new version needs to be uploaded, you must add a new effective dated row within the Template files section and upload a new version of the template. The system does not allow for two templates with the same effective date. See the Upload a Revised Template section of the Creating a CommGen Template page for instructions and screen shots on this process.

Output Tab

Screenshot of the Output tab showing the default pdf button and location field

  1. Always check the Default box on the PDF row.
  2. Ensure the Location is set to Any.
  3. Click Save.

 

Once the report definition is created, you need to update the Letter Code setup to include CommGen parameters.