Thursday, February 09, 2012 ..:: Forums ::.. Register  Login
 Forums Minimize
 
ForumForumMainstream Foru...Mainstream Foru...DevelopersDevelopersReporting multi-select text fieldsReporting multi-select text fields
Previous Previous
 
Next Next
New Post
 7/29/2010 1:35 PM
 

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?

New Post
 7/30/2010 1:11 AM
 

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>", "")

New Post
 7/30/2010 11:43 AM
 

Thank you for the feedback.

Previous Previous
 
Next Next
ForumForumMainstream Foru...Mainstream Foru...DevelopersDevelopersReporting multi-select text fieldsReporting multi-select text fields


  
Copyright (c) 2006-2010 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2012 by DotNetNuke Corporation