title: In statement with parameters in Crystal Report Command object
body: <p>I am trying to modify the code of an exsisting SQL report.  This report uses a command object.  Currently the SQl codes says the following:</p>
  
  <pre><code> WHERE **dept.definition_id ={?Measure}**
       AND (({?Period Interval}=2
               AND dept_qd_later.sum_facts_id IS NULL
               AND dept_qd.DENOMINATOR_QUARTER IS NOT NULL)
       OR ({?Period Interval}=3
               AND dept_md_later.sum_facts_id IS NULL 
               AND dept_md.DENOMINATOR_MONTH IS NOT NULL))
  
   LAST
  </code></pre>
  
  <p>I would like to modify the "Measure Parameter" to accept multiple values.  I have updated the command parameter box to accept multiple values.  I have tried to modify the SQL to the below in statement:</p>
  
  <pre><code> WHERE **dept.definition_id in({?Measure})**
       AND (({?Period Interval}=2
               AND dept_qd_later.sum_facts_id IS NULL
               AND dept_qd.DENOMINATOR_QUARTER IS NOT NULL)
       OR ({?Period Interval}=3
               AND dept_md_later.sum_facts_id IS NULL
               AND dept_md.DENOMINATOR_MONTH IS NOT NULL))) 
   LAST
  </code></pre>
  
  <p>However, when I try to insert multiple measure IDs, the report does not run.  Can someone help me figure out what I am doing wrong?  I am a Crystal novice so please respond in plain language. Thanks!</p>