This online report lists members by chapter, then 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 will 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.
When the report is run from the Membership Structure Definition (MBR000) or Membership Product Definition (MBR001) screen, the primary Member Group is passed to the report, and the user can select the chapter code(s) for which the roster is to be generated or run the roster for all chapters. The online report selects all active chapter members for inclusion in the report.
When the report is run from the Subgroup (CUS001S) screen, the chapter roster is run for the open chapter record.
The members' employer company name is selected from Cus_Relationships, not from Cus_Address_Detail.
Because this roster is an external report, all communication flags are checked, and users have the option of including the organization's logo in the header. Customer ID numbers are not included, nor is additional membership information, such as join date, expiration date, or other membership attributes such as chapter and section membership.