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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2013-03-11 : 09:57:22
|
| In dataset properties, I click on Query Designer button and then click on the exclamation mark to run the stored proc.Then I see a list of parameters which I then populate with sample data to pass to the stored proc.Then several fields is returned.Question, why is it that when I click on the refresh button instead of hte query designer, then the parameters window is not shown and I only see one field in the ReportData window under the dataset I just created.Any thoughts please?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-11 : 12:43:33
|
| refresh button is not for executing procedure. it just refreshes dataset based on latest run query result metadata information and populates grid with resultset. The exclamation mark executes the procedures which is when it prompts for parameter values if procedure has any------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2013-03-12 : 01:15:12
|
| thanks |
|
|
|
|
|
|
dataset properties not working