Hi, For the regulatory purposes I was asked to create a custom report for products to show membership. The report should be in a very simple format: Name Role Doe, John Developer Smith, Susan Tester As no such report is available (my life would be so much easier if Product Membership page had Print button!), I had to create it with help of Claude.AI: Standard section: Project Overview Then in Custom section: Query: SELECT (US.LAST_NAME + '. ' + US.FIRST_NAME) AS MemberName, PM.PROJECT_ROLE_NAME AS AccessLevel FROM SpiraTestEntities.R_ProjectMembership AS PM INNER JOIN SpiraTestEntities.R_Users AS US ON US.USER_ID = PM.USER_ID WHERE US.IS_ACTIVE = True AND PM.PROJECT_ID = ${ProjectId} ORDER BY US.LAST_NAME, US.FIRST_NAME And XSLT: Member Access Level This produced the report. Now, if only I could get rid of the report name in the output... en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/3202.aspxthreadId=3202Vladimir Plotkin (vladimir@inmarsys.com) Hi, For the regulatory purposes I was asked to create a custom report for products to show membership. The report should be in a very simple format: Name Role Doe, John Developer Smith, Susan Tester As no such report is available (my life would be so much easier if Product Membership page had Print button!), I had to create it with help of Claude.AI: Standard section: Project Overview Then in Custom section: Query: SELECT (US.LAST_NAME + '. ' + US.FIRST_NAME) AS MemberName, PM.PROJECT_ROLE_NAME AS AccessLevel FROM SpiraTestEntities.R_ProjectMembership AS PM INNER JOIN SpiraTestEntities.R_Users AS US ON US.USER_ID = PM.USER_ID WHERE US.IS_ACTIVE = True AND PM.PROJECT_ID = ${ProjectId} ORDER BY US.LAST_NAME, US.FIRST_NAME And XSLT: Member Access Level This produced the report. Now, if only I could get rid of the report name in the output... Wed, 27 May 2026 14:48:47 -04002026-05-27T14:48:47-04:00/Support/Forum/spirateam/reports/3202.aspx