Generating reports across multiple projects?

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