title: Crystal Reports 8.5 showing multi-values from parameters on report footer
body: <p>In Crystal Reports 8.5 when I have setup a parameter for multi-value the user enters 90654-90658A. Normally I would use Join() but being that this is not just text but numeric I have tried a few things but with no results.</p>
  
  <pre><code>    Local NumberVar i;
  Local NumberVar j;
  Local StringVar param_values;
  
  if 0 in {?CPT} then
    "CPT #s: All CPTs"
  else
  (
    for i := 1 to UBound ({?CPT}) do
      for j := Minimum ({?CPT}[ i ]) to Maximum ({?CPT}[ i ]) do
        param_values := param_values + "," + CStr (j, "#");
    "CPT #s: " + Mid (param_values, 2)
  )
  </code></pre>
  
  <p>This works fine for 90654-90658 but when the user selects 90654-90658A it fails.</p>
  
  <p>Also the selection criteria will not pass to SQL in the query sent to SQL with the correct where clause. Meaning there is not indication that I am even asking for a where. It should show in the select for sql a where table.data >= '90654' and table.data &lt;= '90658A'</p>
  
  <p>I am lost as to where I am going wrong with this.  Any help would be great this is my first time seeking an answer on this site  but I have not received any help on this request.</p>
  
  <p>Thanks</p>