title: Passing parameters to a report in SSRS but no report
body: <p>I can run the query in management studio and it runs fine, but when I try to run it in ssrs 2008, or pass the parameters from an MVC app, no report.  I am guessing there is some kind of issue with my report parameter settings but I cant see it.</p>
  
  <p>query:</p>
  
  <pre><code>SELECT p.PersonId, p.FirstName + ' ' +  p.LastName as Name, p.FirstName, p.Address, p.City, p.State, p.Zip, l.BodyText, l.CreatedBy
  FROM Person p Join Letter l on p.personid = l.personid
  where l.PersonId = @PersonId
  and l.letterid = @LetterId
  </code></pre>
  
  <p>Parameter settings: @PersonId &amp; @LetterID are both integers, no default value, internal.</p>
  
  <p>link from the app:</p>
  
  <pre><code>("http://MyServer/ReportServer/Pages/ReportViewer.aspx?/Trespass/Letter&amp;rs:Command=Render&amp;PersonId=" + PersId + "&amp;LetterId=" + LetterId);
  </code></pre>
  
  <p>When clicked, it renders this url:</p>
  
  <pre><code>http://MyServer/ReportServer/Pages/ReportViewer.aspx?/Trespass/Letter&amp;rs:Command=Render&amp;PersonId=60&amp;LetterId=22
  </code></pre>
  
  <p>which looks good to me.</p>
  
  <p>Ideas?</p>