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 |
|
AlanS
Starting Member
28 Posts |
 Posted - 2008-10-01 : 17:44:36
|
| Using SSRS 2005, when working with a dataset on the Data tab, while developing or modifying the query, each time I try something that doesn't work, in addition to getting an appropriate error message I intermittently find that all of the @ parameters I've laboriously defined on the Parameters tab of the Dataset properties window just disappear! I then have to manually re-enter all of them and continue working, until the next time I have a syntax or spelling error, when the same thing happens again.Am I missing something here or doing something wrong, or is this just a giant bug that Microsoft has yet to acknowledge, let alone fix? I've generally found SSRS 2005 to be a breath of fresh air after the garbage-level quality of the prior version, but this is really maddening.Any help will be most appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-02 : 03:46:53
|
| thats because you're refreshing the dataset after each trial of your code in datatab. Once you execute a code in your data tab the results will be populated in grid and when you click refresh button, automatically reporting services changes the structure of dataset to be resultset that you got and also takes parameters based on what you've given in query. so if your query doesnt invlove any parameters, it will delete any params that it had created during previous run of query and then you've to enter them manually again. If you need the parameters to stay you need to make sure the query you're trying to run includes the parameters.Also always its better to get the query you want correctly from query analyser and then putting it in reporting services rather than trying the query in datatab itself. |
 |
|
|
|
|
|
Parameters spontaneously disappearing from dataset