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: 374
        
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