Reporting Services keeps erasing my dataset parameters
- by Dustin Brooks
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</SoapAction>
<ElementPath IgnoreNamespaces="true">
TWRPerformanceSummaryResponse/TWRPerformanceSummaryResult/diffgram/NewDataSet/table{StockPerc,RiskBudget,Custodian,ProductName,StartValue(decimal),EndValue(decimal),CostBasis(decimal)}
</ElementPath>
</Query>