I know that SplendidCRM stores multi-select dropdown values as xml data in a text field. If I try to run a report on such columns, it prints out all the XML data into the report.
Is there any way that I can configure the report to not print all that xml data and just list the contents as I see in the detail view field?
The best we can suggest is that you customzie the report to remove the XML. The cool thing about our use of RDL is that you can edit the RDL and call functions. For the specific field value in question, you can try to replace the current value =Fields!TEST_C.Value to something like this:
=Replace(Replace(Replace(Replace(Fields!TEST_C.Value, "<?xml version=""1.0"" encoding=""UTF-8""?>", ""), "</Value><Value>", ", "), "<Values><Value>", ""), "</Value></Values>", "")
Thank you for the feedback.
Copyright (c) 2006-2012 SplendidCRM Software, Inc. All Rights Reserved.