FYI: If you are writing report SQLand run into the following error: "System.Xml.XmlException: The '#' character, hexadecimal value 0x23, cannot be included in a name." ...then make sure you aren't selecting two columns from two separate tables with the exact same name. Use aliasing to prevent the problem. For example, the following SQL will cause a problem: SELECT rel.NAME, req.NAME FROM SpiraTestEntities.R_Releases AS rel LEFT JOIN SpiraTestEntities.R_Requirements AS req on rel.RELEASE_ID = req.RELEASE_ID WHERE rel.PROJECT_ID = ${ProjectId} The following SQL is equivalent except the column name aliases will preclude the aforementioned error: SELECT rel.NAME AS rel_Name, req.NAME AS req_NAME FROM SpiraTestEntities.R_Releases AS rel LEFT JOIN SpiraTestEntities.R_Requirements AS req on rel.RELEASE_ID = req.RELEASE_ID WHERE rel.PROJECT_ID = ${ProjectId} 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/983.aspxthreadId=983Jon Freed (jfreed@edmap.com)reporting FYI: If you are writing report SQLand run into the following error: "System.Xml.XmlException: The '#' character, hexadecimal value 0x23, cannot be included in a name." ...then make sure you aren't selecting two columns from two separate tables with the exact same name. Use aliasing to prevent the problem. For example, the following SQL will cause a problem: SELECT rel.NAME, req.NAME FROM SpiraTestEntities.R_Releases AS rel LEFT JOIN SpiraTestEntities.R_Requirements AS req on rel.RELEASE_ID = req.RELEASE_ID WHERE rel.PROJECT_ID = ${ProjectId} The following SQL is equivalent except the column name aliases will preclude the aforementioned error: SELECT rel.NAME AS rel_Name, req.NAME AS req_NAME FROM SpiraTestEntities.R_Releases AS rel LEFT JOIN SpiraTestEntities.R_Requirements AS req on rel.RELEASE_ID = req.RELEASE_ID WHERE rel.PROJECT_ID = ${ProjectId} Mon, 25 Aug 2014 20:42:41 -04002014-08-28T13:38:59-04:00/Support/Forum/spirateam/issues-questions/983.aspxmessageId=1800Kat A (elise.brooks@inflectra.com) Thanks for the information, Jon!Thu, 28 Aug 2014 13:38:59 -04002014-08-28T13:40:00-04:00/Support/Forum/spirateam/issues-questions/983.aspx#reply1800