Hi, I see somebody else asked this question before and Adam replied to it but I still need more help because I'm afraid I do not know the database table names, entities, etc. and it seems that I may need to add more fields to the report section to be able to get the results I'm ambitioning. My Idea is to see how many projects are assign to a specific person based on a release and progress. Is there a way to choose different progress status at the same time from the progress drop-down list? and also is there a way to add customized options to the progress drop-down list? Here is the answer Adam provided to the other customer. " 1) You can create a custom report (in Administration > Edit Reports) and add a custom section. In that custom section add a query against the R_ ProjectReleaseResources entity and that will let you report on resources." Thanks! Lina Betancourth 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/issues-questions/630.aspxthreadId=630Lina Betancourth (lbetancourth@motionpoint.com) Hi, I see somebody else asked this question before and Adam replied to it but I still need more help because I'm afraid I do not know the database table names, entities, etc. and it seems that I may need to add more fields to the report section to be able to get the results I'm ambitioning. My Idea is to see how many projects are assign to a specific person based on a release and progress. Is there a way to choose different progress status at the same time from the progress drop-down list? and also is there a way to add customized options to the progress drop-down list? Here is the answer Adam provided to the other customer. " 1) You can create a custom report (in Administration > Edit Reports) and add a custom section. In that custom section add a query against the R_ ProjectReleaseResources entity and that will let you report on resources." Thanks! Lina Betancourth Tue, 02 Jul 2013 14:07:23 -04002013-07-03T16:00:37-04:00/Support/Forum/spirateam/issues-questions/630.aspxmessageId=1156David J (adam.sandman+support@inflectra.com)Hi Lina You would need to use the R_ProjectReleaseResources entity, and/or you can join other tables/entities to that using SQL Joins to get additional columns. Without knowing exactly what you're looking to achieve, I cannot give the exact SQL. If you can list out the columns you need I can see what might be possible. Also in terms of the other questions, there is not a way to add additional customized options to the progress drop-down, and that dropdown is not currently multi-selectable. Wed, 03 Jul 2013 16:00:37 -04002013-07-03T16:00:37-04:00/Support/Forum/spirateam/issues-questions/630.aspx#reply1156