Topic: Splitting a string and setting parameter on it Posted: 02 Mar 2011 at 12:11am
Hi
I have a comma separated string field Mail_Prefs that I need to spilt and then create a parameter field in the selection record that looks at the array.Any suggestions?
I can Spilt the field into an array but I can't make that a formula (as the result of a formula cannot be an array that the parameter then references.
Am I better off creating a view that makes the array first somehow and the Crystal parameter then references?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 02 Mar 2011 at 4:30am
if you want a dynamic LOV in the param defined by the data in the string you will have to use a stored proc or view to extract it and use that as the source.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum