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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2010-04-01 : 08:28:34
|
| I want to add report parameters to a sql server report service 2008 that has been generated by the report wizard and have the parameters work.I can get the report parametes to look like they work by doing the following: 1. select view then report data then right click parameters in the report data window. 2. I then select add parameters then enter a 'name' then enter a prompt name and then select data type. 3. I then right click on the dataset and then click dataset properties and then click on parameteres in the dataset properties window and add the parameters I want. The above looks ok, but the parameters do not work. What do I need to do get the report parameters to work either after a new report has been setup using the report wizard and/or adding the report parameters to work at a later time. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-01 : 09:23:04
|
What's about the query that fills your dataset?It should consider the new parameters.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-04-01 : 11:04:42
|
| My sql server report service 2008 report is calling a stored procedure. Thus, how do I tie the parameters in the stored procedure to the sql server 2008 report? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-01 : 11:08:12
|
Have a look in the source code of the stored procedure.There you can see how the parameters that work are tied.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-01 : 12:14:03
|
quote:
Originally posted by jassie
My sql server report service 2008 report is calling a stored procedure. Thus, how do I tie the parameters in the stored procedure to the sql server 2008 report?
by default when you execute stored procedure in data tab of report and refresh it populates the dataset info with fields in your resultset and at the same time creates parameters in your report corresponding to ones in procedure. you need to go to parameter tab then and change any properties if you want------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-01 : 13:10:35
|
That means: The parameters should be in the stored procedure though!
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-01 : 13:13:08
|
quote:
Originally posted by webfred
That means: The parameters should be in the stored procedure though!
No, you're never too old to Yak'n'Roll if you're too young to die.
if you want them to come automatically. Otherwise you need to add parameters manually through parameters tab and use them in filtering within report/dataset yourself.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
get report parameters to work