Does Arena already have a report for Tags that will display notes attached to the tag members?
Charlene SmithDatabase CoordinatorSt. Andrew's UMCOmaha, NE
DECLARE@PROF INT = XXX
SELECTCPM.person_id AS [person_id],P.last_name + ', ' + P.nick_name AS [person_name],CPM.notes AS [Notes]FROMcore_profile_member CPMLEFT JOIN core_person P ON P.person_id = CPM.person_idWHERECPM.profile_id = @PROFORDER BYP.last_name , P.nick_name
If an SQL query will work for you just replace the XXX with the Profile/Tag ID and this will work for you.
Remember to always backup your DB before running an SQL command.
I made a very basic one a long time ago. It's in the community downloads: http://community.shelbysystems.com/arena/m/reports/7725
Great thank you.