title: SSRS stored procedure with parameters as dataset not working
body: <p>In my report i use 3 stored procedures. All of them are using parameters, and 2 of them work perfect and the third one is not, which i really do not understeand. </p>
  
  <p>Stored procedure takes 2 parameters </p>
  
  <pre><code>       SPgetData @reportnr,@username
  </code></pre>
  
  <p>The parameter @username is also used by the 2 other SP's</p>
  
  <p>If I call in dataset Query Text then it works, but then I have to specify the parameters by hand like :</p>
  
  <pre><code>    SPgetData '001','Administrator'
  </code></pre>
  
  <p>If I try to set Text to </p>
  
  <pre><code>   SPgetData @reportNr,@username it opens the screen to enter the values by hand.. 
  </code></pre>
  
  <p>This is really very strange as 2 other procedures work perfectly with exact the same setup (As Stored Procedure with reportParameters...</p>
  
  <p>This is not a limitation problem of 3 procedures or something because I tested this on a another report.rdl file and it didn't work also...</p>