Skip Navigation LinksForums > SpiraTeam Forums > SpiraTeam Issues & Questi... > Generating reports across...

Generating reports across multiple projects? RSS Feed

Thursday, September 11, 2014
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?
1 Replies
Adam SAdam S
re: Steve Pelikan on Thursday, September 11, 2014
Friday, September 12, 2014

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.



  • Started: 9/11/2014
  • Last Reply: 9/12/2014
  • Replies: 1
  • Views: 903
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2017 | Licensed to Inflectra Corporation.