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 |
|
SCHEMA
Posting Yak Master
192 Posts |
 Posted - 2008-07-31 : 21:11:11
|
| I have :Declare @Endmonth char(6)......... andsql statements.How do I match with parameter? I created parameter Endtime in Report paramater? But how do i match with Declare @Endmonth. It is not working.Do i have to change it to stored procedure? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-08-01 : 02:45:26
|
| Please show that statement. What is the meaning of "not working". Any errors?WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-01 : 13:47:10
|
quote:
Originally posted by SCHEMA
I have :Declare @Endmonth char(6)......... andsql statements.How do I match with parameter? I created parameter Endtime in Report paramater? But how do i match with Declare @Endmonth. It is not working.Do i have to change it to stored procedure?
just run query in data tab and populate data grid of report and click refresh. automatically reporting services will create the parameters for you corresponding to your query and map it the query params |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-04 : 03:38:20
|
| Then you can delete your Endtime parameter as you won't need it. |
|
|
|
|
|
|
matching with parameters