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

Related posts about reporting-services

Related posts about ssrs