Hi there, I want to generate a report to show the number of projects/or products in rls6.x with created date, I couldnt find this was asked in the past. Does anyone know if its possible to do so and if yes, how? Thanks! 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/2122.aspxthreadId=2122Tung Nguyen (tran.nguyen@transport.nsw.gov.au)products report Hi there, I want to generate a report to show the number of projects/or products in rls6.x with created date, I couldnt find this was asked in the past. Does anyone know if its possible to do so and if yes, how? Thanks! Mon, 09 Dec 2019 03:06:24 -05002019-12-13T12:07:44-05:00/Support/Forum/spirateam/reports/2122.aspxmessageId=3701David J (adam.sandman+support@inflectra.com) Hi Please use a custom report with this query: select R.PROJECT_ID, R.NAME, R.CREATION_DATE from SpiraTestEntities.R_Projects as R order by R.CREATION_DATE desc Regards David Fri, 13 Dec 2019 12:07:44 -05002019-12-13T12:07:44-05:00/Support/Forum/spirateam/reports/2122.aspx#reply3701