hi, I try to prepare my custom report. I create query: select R.TEST_CASE_ID, R.NAME, R.AUTHOR_NAME, R. DESCRIPTION, T.TEST_STEP_ID, T.DESCRIPTION, I.INCIDENT_NAME, I.CREATION_DATE, I.CLOSED_DATE, I.LAST_UPDATE_DATE from SpiraTestEntities.R_TestCases as R inner join SpiraTestEntities.R_TestSteps as T on R.TEST_CASE_ID = T.TEST_CASE_ID inner join SpiraTestEntities.R_Incidents as I on T.TEST_STEP_ID = I.TEST_RUN_STEP_ID where R.PROJECT_ID = ${ProjectId} As a result I achieved system warning: "System.Xml.XmlException: The '#' character, hexadecimal value 0x23, cannot be included in a name." I change my query to form: select R.TEST_CASE_ID, R.NAME, R.AUTHOR_NAME, T.TEST_STEP_ID, T.DESCRIPTION, I.INCIDENT_NAME, I.CREATION_DATE, I.CLOSED_DATE, I.LAST_UPDATE_DATE from SpiraTestEntities.R_TestCases as R inner join SpiraTestEntities.R_TestSteps as T on R.TEST_CASE_ID = T.TEST_CASE_ID inner join SpiraTestEntities.R_Incidents as I on T.TEST_STEP_ID = I.TEST_RUN_STEP_ID where R.PROJECT_ID = ${ProjectId} and then the proper result is generated. System warning "System.Xml.XmlException: The '#' character, hexadecimal value 0x23, cannot be included in a name." appears always when I want to display two columns with the same name (even if they refer to different tables -> R. DESCRIPTION and T.DESCRIPTION ) How can I resolve my problem? 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/spiratest/issues-questions/1015.aspxthreadId=1015Kasia G. (kasia5002@gmail.com)reporting hi, I try to prepare my custom report. I create query: select R.TEST_CASE_ID, R.NAME, R.AUTHOR_NAME, R. DESCRIPTION, T.TEST_STEP_ID, T.DESCRIPTION, I.INCIDENT_NAME, I.CREATION_DATE, I.CLOSED_DATE, I.LAST_UPDATE_DATE from SpiraTestEntities.R_TestCases as R inner join SpiraTestEntities.R_TestSteps as T on R.TEST_CASE_ID = T.TEST_CASE_ID inner join SpiraTestEntities.R_Incidents as I on T.TEST_STEP_ID = I.TEST_RUN_STEP_ID where R.PROJECT_ID = ${ProjectId} As a result I achieved system warning: "System.Xml.XmlException: The '#' character, hexadecimal value 0x23, cannot be included in a name." I change my query to form: select R.TEST_CASE_ID, R.NAME, R.AUTHOR_NAME, T.TEST_STEP_ID, T.DESCRIPTION, I.INCIDENT_NAME, I.CREATION_DATE, I.CLOSED_DATE, I.LAST_UPDATE_DATE from SpiraTestEntities.R_TestCases as R inner join SpiraTestEntities.R_TestSteps as T on R.TEST_CASE_ID = T.TEST_CASE_ID inner join SpiraTestEntities.R_Incidents as I on T.TEST_STEP_ID = I.TEST_RUN_STEP_ID where R.PROJECT_ID = ${ProjectId} and then the proper result is generated. System warning "System.Xml.XmlException: The '#' character, hexadecimal value 0x23, cannot be included in a name." appears always when I want to display two columns with the same name (even if they refer to different tables -> R. DESCRIPTION and T.DESCRIPTION ) How can I resolve my problem? Thu, 25 Sep 2014 09:55:48 -04002014-09-25T15:16:14-04:00/Support/Forum/spiratest/issues-questions/1015.aspxmessageId=1851taha massalha (taha@annapurnalabs.com) Hi Try to use alias with those columns: use T.DESCRIPTION AS TEST_STEP_ DESCRIPTION and R .DESCRIPTION AS TEST_CASE_ DESCRIPTION BR, Taha Massalha Thu, 25 Sep 2014 15:16:14 -04002014-09-25T15:16:14-04:00/Support/Forum/spiratest/issues-questions/1015.aspx#reply1851