title: how to use common function in query expression?
body: <p>I want to use the "split" function in a simple query on my SSRS 2008 report.  However, I get an error "Query execution failed for dataset "SlsmRealNum". "Split" is not a recognized built-in function name".  But it's listed as a common function (text) if I open up the Expression box on the query, so not sure why it's failing?</p>
  
  <p>my simple select statement is: </p>
  
  <pre><code>select slsm_num, slsm_msid from Salesman where slsm_msid = split(User.UserID,"\").GetValue(1)
  </code></pre>
  
  <p>right now to get the report to work, I have one parameter (SlsmnNum) that has the Split expression in it (to get the MSID of the user) and then a 2nd parameter that uses the above query in the Dataset Salesrepum using the @SlsmnNum parameter as the MSID.   I'd like to not have to have 2 parapmeters if possible and just get the actualy salesrep # in just one.  Any help is greatly appreciated!</p>