Replacing the Hard-Coded Date Field with an SSRS Parameter
Posted on 2011-03-24
I have a very lengthy query that I have been testing in SQL 2005 Management Studio. Now that I have finished testing it, I was going to place this query into the "Data" tab of SQL Reporting Services (SSRS). But, as I just found, the "Data" tab has a character limitation. So, not all of my query gets pasted in.
OK. I'm going to have to take this query, then, and make it into a view in SQL and pull that view into SSRS. I have done that before many times and need no help with that.
Here's the problem, though. In about 400 spots throughout the query, I have a hard-coded date that I have been testing my query with. My intent with all of this is to create a Date parameter in SQL Reporting Services that will prompt the user with a date to run the report on. I need for that "Run Date" to replacte the hard-coded date in my query.
That's why I simply wanted to copy and paste the query into the "Data" tab, so that I could do a simple "find and replace" and replace this hard-coded date with the SQL parameter. But, siince there is this really wonderful character limitation, I cannot do so.
I don't know that I can create a view, either, though. I mean, if I do that, I guess that's fine. But, how in the world do I tell SQL Reporting Services to replace the hard-coded date in the query (i.e. the view) with the Run Date parameter?