<rss version="2.0" xmlns:a10="http://www.w3.org/2005/Atom"><channel><title>Inflectra Customer Forums: Simple project membership report (Thread)</title><description> 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...  </description><language>en-US</language><copyright>(C) Copyright 2006-2026 Inflectra Corporation.</copyright><managingEditor>support@inflectra.com</managingEditor><category domain="http://www.dmoz.org">/Computers/Software/Project_Management/</category><category domain="http://www.dmoz.org">/Computers/Software/Quality_Assurance/</category><generator>KronoDesk</generator><a10:contributor><a10:email>support@inflectra.com</a10:email></a10:contributor><a10:id>http://www.inflectra.com/kronodesk/forums/threads</a10:id><ttl>120</ttl><link>/Support/Forum/spirateam/reports/3202.aspx</link><item><guid isPermaLink="false">threadId=3202</guid><author>Vladimir Plotkin (vladimir@inmarsys.com)</author><title>Simple project membership report</title><description> 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...  </description><pubDate>Wed, 27 May 2026 14:48:47 -0400</pubDate><a10:updated>2026-05-28T09:57:35-04:00</a10:updated><link>/Support/Forum/spirateam/reports/3202.aspx</link></item><item><guid isPermaLink="false">messageId=7654</guid><author>Victoria D (nino.diasamidze@inflectra.com)</author><title> Hello,  Are you referring to the report caption itself or the Print Report hyperlink positioned in </title><description> Hello,  Are you referring to the report caption itself or the Print Report hyperlink positioned in the top-left corner of the output page?     Regards, Victoria - </description><pubDate>Thu, 28 May 2026 05:35:12 -0400</pubDate><a10:updated>2026-05-28T05:35:12-04:00</a10:updated><link>/Support/Forum/spirateam/reports/3202.aspx#reply7654</link></item><item><guid isPermaLink="false">messageId=7657</guid><author>Vladimir Plotkin (vladimir@inmarsys.com)</author><title> Hi,  When a report is generated, the name of the report is always inserted into it.  For example, i</title><description> Hi,  When a report is generated, the name of the report is always inserted into it.  For example, if my report is called Simple project membership report, the very first line in the resulting document would be    Simple project membership report   </description><pubDate>Thu, 28 May 2026 07:39:30 -0400</pubDate><a10:updated>2026-05-28T07:39:30-04:00</a10:updated><link>/Support/Forum/spirateam/reports/3202.aspx#reply7657</link></item><item><guid isPermaLink="false">messageId=7658</guid><author>Victoria D (nino.diasamidze@inflectra.com)</author><title> Hello,  Thank you for the additional details - that makes things clear.  So yes, this is completely</title><description> Hello,  Thank you for the additional details - that makes things clear.  So yes, this is completely possible with some simple CSS block, placed right after   and before the table:        
      .Title1 { display: none; }
        Heres the full XSLT with the fix applied:    
 
   
     
      .Title1 { display: none; }
     
     
       
.............
         
       
              Regards, Victoria - </description><pubDate>Thu, 28 May 2026 08:31:49 -0400</pubDate><a10:updated>2026-05-28T08:43:01-04:00</a10:updated><link>/Support/Forum/spirateam/reports/3202.aspx#reply7658</link></item><item><guid isPermaLink="false">messageId=7659</guid><author>Vladimir Plotkin (vladimir@inmarsys.com)</author><title> Thanks for suggestion.  It works for HTML output but not for Word or Excel. </title><description> Thanks for suggestion.  It works for HTML output but not for Word or Excel. </description><pubDate>Thu, 28 May 2026 09:37:10 -0400</pubDate><a10:updated>2026-05-28T09:37:10-04:00</a10:updated><link>/Support/Forum/spirateam/reports/3202.aspx#reply7659</link></item><item><guid isPermaLink="false">messageId=7660</guid><author>Victoria D (nino.diasamidze@inflectra.com)</author><title> Hello,  Thats correct: it works with HTML only and theres no XSLT-based workaround for this. The re</title><description> Hello,  Thats correct: it works with HTML only and theres no XSLT-based workaround for this. The report title is added as a document heading before XSLT output is rendered. XSLT only controls the content of each custom section, not the report-level wrapper that includes the title.  I can add an enhancement about having that option to suppress the report name in exports, or allow the XSLT to control whether the title is rendered.     Regards, Victoria - </description><pubDate>Thu, 28 May 2026 09:51:34 -0400</pubDate><a10:updated>2026-05-28T09:51:34-04:00</a10:updated><link>/Support/Forum/spirateam/reports/3202.aspx#reply7660</link></item><item><guid isPermaLink="false">messageId=7661</guid><author>Vladimir Plotkin (vladimir@inmarsys.com)</author><title> Yes, an option to suppress it would be great!  Thank you </title><description> Yes, an option to suppress it would be great!  Thank you </description><pubDate>Thu, 28 May 2026 09:57:35 -0400</pubDate><a10:updated>2026-05-28T09:57:35-04:00</a10:updated><link>/Support/Forum/spirateam/reports/3202.aspx#reply7661</link></item></channel></rss>