CiviCRM Community Forums (archive)

I have contacts with three different membership types (call them A, B, and C), assigned to three different smart groups based on membership type.  Each contact has a custom field called Employer (since there is a bug that keeps the value in Current Employer to show up in listings).  I need to create a listing that contains all of the employers and the state they are in (the state value for each Individual contact, since the address used is their work address) for those with membership types A and B.  How do I do that?  Do I just create a profile that has those two fields?  I tried that, and the problem is that it also includes the name of the contact by default, which isn't what I want.

Thanks.

Ok, but how do I limit it to Employer fields for two certain groups?  I can create a custom search, but it will return a whole bunch of fields.  Taking the profile route, I can only limit it to one group, not two groups.  Is there a happy medium?  For instance, do I need to create a custom template for  the search results that only has the two columns I need?

Thanks.