Reporting Services keeps erasing my dataset parameters

Question

I'm using a web service and every time I change something on the dataset, it erases all my parameters.

The weird thing is, I can execute the web service call from the data tab and it prompts for all my parameters, but if I click to edit the data the list is empty or if I try to preview the report it blows up because parameters are missing.

Just wondering if anyone else has experienced this and if there is a way to prevent this behavior.

Here is a copy of the dataset, not that I think it matters. This has to be the most annoying bug (if its a bug) ever. I can't even execute the dataset from the designer without it erasing my parameter list. When you have about 10 parameters and you are making all kinds of changes to a new report, it becomes very tedious to be constantly re-typing the same list over and over.

If anything, studio should at least be able to pre-populate with the parameters the service is asking for. sigh Wheres my stress ball...

<Query>
   <Method Namespace="http://www.abc.com/" Name="TWRPerformanceSummary"/>
   <SoapAction>http://www.abc.com/TWRPerformanceSummary&lt;/SoapAction&gt;   
       <ElementPath IgnoreNamespaces="true">
            TWRPerformanceSummaryResponse/TWRPerformanceSummaryResult/diffgram/NewDataSet/table{StockPerc,RiskBudget,Custodian,ProductName,StartValue(decimal),EndValue(decimal),CostBasis(decimal)}
       </ElementPath>
</Query>

Answer 1

I get this, and it's pretty annoying. If you are developing from VS, just click on the Refresh fields button, and it normally clears up the problem. If the query STILL throws an error, your SQL most likely has a bug in it (at least in my experience if "refresh fields" doesn't work, I made some stupid syntax error like "SELECT Field1 Field2..." or something like that). You could also click the "Run query" button.