title: Passing a variable as a parameter to an ssrs report
body: <p>I am trying to pass a variable from my classic asp page to ssrs.  When I put in a literal value for the parameter, such as 296, it works fine.  But I want to put in a variable that is sent by the URL so that it works in different ways for different people who are logged in.  So, instead of a URL that is <a href="http://servername.net/reportserver....rs:Command=Render&amp;Agency=296" rel="nofollow">http://servername.net/reportserver....rs:Command=Render&amp;Agency=296</a> (for the agency that is number 296) I want to use a variable that I have set to the agency of the person who has logged in.  Let's say the variable is pAgency.  I have tried Agency=" @pAgency (I set pAgency = to the logged in person's agency) and all sorts of other combinations, and have searched the web, but find no answer for this.  I've even tried session variables but, no go.  You must be able to do this but...</p>
  
  <p>Thanks for any help you can give.  Cheers!</p>