title: Populate an SSRS Report parameter(hidden) by a sproc or user defined function
body: <p>My SSRS report fetches data from my DATAWAREHOUSE.</p>
  
  <p>The ASP.NET application I have is connected to an OLTP database.</p>
  
  <p>I invoke the SSRS Report from my ASP.NET application and provide a parameter as CustomerID(this is an application key in datawarehouse) to my report.</p>
  
  <p>Since my report is connected to my datawarehouse, I do not query my report databased on the OLTP's CustomerID. Instead I use my datawarehouse's surrogate key (CustomerDimKey).
  Now, in my report, I need to find the correct surrogate key for the CustomerID parameter, which I passed from my ASP.NET application!</p>
  
  <p>My report already has a parameter as @CustomerDimKey(this is used across all the report sprocs). We used it for testing, but now we'll hide this as we have integrated it with the ASP.NET application.</p>
  
  <p>I have already added a new parameter to the report as @CustomerID(this will have the OLTP's CustomerID), which will now get a value from ASP.NET.</p>
  
  <p>I need to know a way to re-use the @CustomerDimKey report parameter, which should now get value from a sql statement or a sproc once the report is requested.
  Based on the value contained by the @CustomerID parameter.</p>