title: Issue with dataset Creation
body: <p>I am new to ssrs and having difficulty defining parameters. I am trying to develop a code which will determine the parameters based on report type value 1 or 2. </p>
  
  <p>I tried defining the parameters at run time using variables but no luck</p>
  
  <pre><code>SELECT  A.PRV_TIN_NO,
             B.CLM_PD_DT,
             A.CLM_FROM_DOS_DT,
             a.CLM_THRU_DOS_DT,
             A.GRP_NO 
      FROM CBDW.CBDW_CLM_MEDCL_HDR A
      INNER JOIN CBDW.CBDW_CLM_MEDCL_HDRLN B 
       ON A.GRP_NO = B.GRP_NO     
     WHERE (
      (@reporttype=1
        AND A.GRP_NO = @grpNo
        AND b.CLM_PD_DT &gt;= @PaidfromDate
           AND b.CLM_PD_DT &lt;=@PaidToDate
       )
  OR 
            (@Reporttype=2
               AND A.GRP_NO = @grpNo
                AND a.CLM_FROM_DOS_DT&gt;=@fromDate
                AND a.CLM_THRU_DOS_DT &lt;=@ToDate
                AND b.CLM_PD_DT &lt;=@PaidToDate
                     )
  )
  </code></pre>
  
  <p>I am expecting to ssrs to prompt report type and when I select 1 parameters should be groupnumber and claim paid start date and end date while in option 2 I should also have service date parameter/</p>