Inflectra Customer Forums: Generating reports across multiple projects? (Thread) We're trying to gather data across projects, but SpiraTeam does not provide portfolio functionality. Is there a way to run a cross-project SQL query on an Inflectra-hosted implementation?en-US(C) Copyright 2006-2024 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/issues-questions/1000.aspxthreadId=1000Steve Pelikan (steve.pelikan@wizards.com)SpiraTeam SQL hostedGenerating reports across multiple projects? We're trying to gather data across projects, but SpiraTeam does not provide portfolio functionality. Is there a way to run a cross-project SQL query on an Inflectra-hosted implementation?Thu, 11 Sep 2014 21:57:27 -04002014-09-12T18:04:18-04:00/Support/Forum/spirateam/issues-questions/1000.aspxmessageId=1825David J (support1@inflectra.com) Hi Steve Yes you can do this as long as you have system administration permissions (because Hi Steve Yes you can do this as long as you have system administration permissions (because SQL level access will violate the role based security in the system naturally). So to access it, please go to: Administration > System > Edit Reports. Create a new custom report. Add a custom section to the report. Then from the dropdown list, choose the base query (e.g. requirements) and now you have a SQL entry window and a preview option. Once you are happy with the data, you can use the 'Create Template' to build a displayable XML template for the report. Regards Adam Fri, 12 Sep 2014 18:04:18 -04002014-09-12T18:04:18-04:00/Support/Forum/spirateam/issues-questions/1000.aspx#reply1825