MBR1211PI – Chapter Membership List Roster, Geographic (Internal)

This online report lists members by chapter, by country and state of the member's primary address, and then by member name. The report contains member information at the individual level, to serve the needs of professional associations (where individuals are members). Members who belong to more than one chapter appear on the roster for each chapter to which they belong. For this reason, the report selects chapter members based on current order records in the Order_Detail table, because the Cus_Membership_Info_VW only contains information about the first two chapters to which a member belongs.

 

Each member's employer company name is selected from Cus_Relationships, not from Cus_Address_Detail.

 

Because this roster is an internal report, no communication or publish flags are checked, and the organization's logo is not included in the header. Customer ID numbers are included, as is information about membership join date and expiration dates, as well as chapter and section memberships if applicable.

Sample Report

mbr1211pi.jpg