Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2007-06-21 : 06:16:41
|
Hi all, Im new to SSRS, basically I have created and deployed a report to my reporting server. Now I have a query parameter on my report. From my application, I can access the report manager, and here it asks me for my variable. I'm not sure if my question is a vb.net one, but I was wondering if anyone knew how I could pass my query paramater to SSRS at runtime. Basically it would be easier for my users if they could just see the report they are interested in, rather than having to type the variable in to be able to see the report. Thanks for your time. Pace"Impossible is Nothing"  |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-06-22 : 13:52:18
|
| The idea is that you create a place holder for the input param when you design your report, just like a wild card in the where clause, some thing like:Select <fld list> from tbl where myID= ?Then at the run time, in your dotnet code, when you initiate the report, supply the value.Another way is that you build the report on the fly, including the underlying query all together.I have done it on my previous job, but I don't have a sample. So you have to figure out the syntax on your own or google it. |
 |
|
|
|
|
|
|
|
New to SSRS - Pass query paramater at runtime