title: How can i restrict parameters in SSRS?
body: <p>i have one SP as below</p>
  
  <pre><code>CREATE procedure [dbo].[SAMPLE]
  (
  @ID varchar(20)=null,      
  
  @FromDate varchar(20)=null,
  @ToDate varchar(20)=null,
  @LastDate varchar(20)=null,
  @TransType varchar(50)  = '',
  @ProviderId varchar(max)=null,
  @Payerid varchar(max)=null,
  @PageNum    int =1,
  @PageSize int=10,
  @Mode int=0,
  @DateType  varchar(20)=null,
  @SortOrder varchar(10)='',
  @SortColumn varchar(50)=''
  )
  </code></pre>
  
  <p>in procedure , some logic is implemented.</p>
  
  <p>now i have to generate report in SSRS by using the above sp</p>
  
  <p>i follwed the method like datasource creation , data set created by selecting query type as stored procedure , now it shows all above parameters. now i want to pass parameter only for id ,and it have to display data <strong>if id is exist</strong> in my table . but i have to display all those parameters but these parameters <strong>should not ask</strong> to pass the values for it. </p>
  
  <p>can any body provide me solution for it. because i am facing strugle from 3 days onwards.</p>
  
  <p><strong>remeMber</strong> that it is not a drilldown or drill through or subreport. it is simple report created from Stored PROCEDURE</p>
  
  <p>thanks in advance</p>