Inflectra Customer Forums: Error in report for custom values (Thread) Hi, Im generating report which includes a custom value and followed the instruction, https://www.inflectra.com/Support/KnowledgeBase/KB369.aspx i managed to get the report from the custom fields, however with the one using for the Date data type, its showing error Heres the error message in the Event Log Messages: An error occurred while reading from the store providers data reader. See the inner exception for details. [System.Data.EntityCommandExecutionException] Conversion failed when converting the nvarchar value 2020-03-11T13:00:00.000 to data type int. [System.Data.SqlClient.SqlException] at APPLICATION.Business.ReportManager.ReportCustomSection_ExecuteSQL(Int32 projectId, Int32 projectGroupId, String sql, UpdateBackgroundProcessStatus updateBackgroundProcessStatus, Int32 progress, Int32 numberOfRecords) My suspect is with the conversion from Date type to Int32 or something like that Anyone knows how to fix this? Many thanks en-US(C) Copyright 2006-2024 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/2157.aspxthreadId=2157Tung Nguyen (tran.nguyen@transport.nsw.gov.au)Error in report for custom values Hi, Im generating report which includes a custom value and followed the instruction, https://www.inflectra.com/Support/KnowledgeBase/KB369.aspx i managed to get the report from the custom fields, however with the one using for the Date data type, its showing error Heres the error message in the Event Log Messages: An error occurred while reading from the store providers data reader. See the inner exception for details. [System.Data.EntityCommandExecutionException] Conversion failed when converting the nvarchar value 2020-03-11T13:00:00.000 to data type int. [System.Data.SqlClient.SqlException] at APPLICATION.Business.ReportManager.ReportCustomSection_ExecuteSQL(Int32 projectId, Int32 projectGroupId, String sql, UpdateBackgroundProcessStatus updateBackgroundProcessStatus, Int32 progress, Int32 numberOfRecords) My suspect is with the conversion from Date type to Int32 or something like that Anyone knows how to fix this? Many thanks Wed, 18 Mar 2020 00:50:07 -04002020-03-20T00:31:25-04:00/Support/Forum/spirateam/reports/2157.aspxmessageId=3747David J (support1@inflectra.com) For those curious about this issue: You only need the join onto the custom property values entity For those curious about this issue: You only need the join onto the custom property values entity if you have a list or multi-list property. For simple values (text, numeric, dates), the data is in the main entity itself (i.e. Custom_XX contains the value itself) Thu, 19 Mar 2020 11:43:34 -04002020-03-19T11:43:34-04:00/Support/Forum/spirateam/reports/2157.aspx#reply3747messageId=3748Tung Nguyen (tran.nguyen@transport.nsw.gov.au) Hi David, I think this info may confuse people and lead to misunderstanding. From the KB link I sha Hi David, I think this info may confuse people and lead to misunderstanding. From the KB link I shared which I assume we have to cast all custom fields to get the actual data instead of its ID However it will not include the display names of any custom list fields, only text ones. Custom list fields will display just the ID of the value, not the display name. To display the name, we will need to join the R_CustomListValues entity to the result Thanks, Fri, 20 Mar 2020 00:31:25 -04002020-03-20T00:31:25-04:00/Support/Forum/spirateam/reports/2157.aspx#reply3748