title: SSRS with JDE query concatanate
body: <p>I have an SSRS report that is connecting to a JDE data source.
  In the dataset for my query I am trying to concatanate three columns.
  I tried the concat function, I tried two bars, I tried the plus sign, everything fails.
  for example:
  concat(col1, col2, col3) as &quot;keylookup&quot;
  col1 || col2 || col3 as &quot;keylookup&quot;
  col1 + col2 + col3 as &quot;keylookup&quot;</p>
  <p>Is there a way that works for both SSRS and JDE?</p>
  <p>Also is there a cast functiob or equivalent for JDE that SSRS supports?</p>
  <p>Thanks</p>