February 9, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Hashes in returned resultsHashes in returned results
Previous Previous
 
Next Next
New Post
 8/2/2007 6:54 AM
 
I have just downloaded the trial version and I am reasonably impressed, but I have an issue around the Lookup lists that allow multi selects.  In between each record, there is a #n; # where n appears to be the ID of the lookup value.  Does anyone know how to get around this?

Cheers,

Chris.
New Post
 8/2/2007 1:47 PM
 
 Modified By Frédéric LATOUR  on 8/2/2007 2:59:08 PM

Hi,
Indeed we do not cleanup properly the multi-value fields (multi choice, mutli lookup, multi person or group)  in the current version.
There is however an easy workaround that involves writing a small function within the report.

Select Report - Report Properties... in the Report Designer menu
Select the Code tab in the Report Properties dialog.
Copy the following function:

Public Function CleanUpMulti( ByVal s As String) As String
    Dim RegObj As New System.Text.RegularExpressions.RegEx(";#\d*(;#)?")
   
    Return RegObj.Replace(s, "; ")

End Function

Now, instead of retrieving directly the field value in the Report Layout View (eg : =Fields!Customers.Value), use the provided function (eg: =Code.CleanUpMulti(Fields!Customers.Value)).

The function uses a regular expression to replace the unwanted pattern by a semicolon and a space. You could obviously change the replacement string  as you like (eg: " - " or  vbLf, etc).

In the next version of ERSDE, we will be handling automatically the cleanup.
More interestingly, we will also be providing the possibility to duplicate items for specific multi-value fields so that it will be possible to group on such a field.
Let me know if that doesn't help.
Regards,


Frederic LATOUR
ENESYS
New Post
 8/3/2007 3:06 AM
 
Frédéric - Worked like a charm, Awesome.  I will be reccomending my clients buy this product!
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Hashes in returned resultsHashes in returned results

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement