Reporting Services keeps erasing my dataset parameters
Posted
by Dustin Brooks
on Stack Overflow
See other posts from Stack Overflow
or by Dustin Brooks
Published on 2009-01-15T14:23:12Z
Indexed on
2010/03/15
17:19 UTC
Read the original article
Hit count: 324
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>
© Stack Overflow or respective owner