XML DataSource / Designer Dataset definition failure

hi all,

i'm using a webservice as datasource for my report which returns a dataset.

i use the following query to get my data:

<Query>
<Method Namespace="http://tempuri.org/" Name="GetInvoiceData"/>
<SoapAction>http://tempuri.org/GetInvoiceData</SoapAction>
<ElementPath IgnoreNamespaces="true">GetInvoiceDataResponse/GetInvoiceDataResult/diffgram/Invoice/invPosition</ElementPath>
</Query>

i use the ElementPath element to get the correct datatable of my resultset. and i have a parameter(invID) to get a specific invoice i want.

everything works fine when i run this command... But when i want to refresh the fields list for the report desginer, only three fields are available in the designer and always the same: diffgr, msdata, xmlns.

After a few tests i just found out that the parameter in my report "causes" the problem.When the designer tries to get the schema of the current dataset, he'll not pass the parameter to the webservice. so the soap call fails and the wrong dataset schema appears in the report designer.

could someone please help me

regards

Antilles

Answer this question

XML DataSource / Designer Dataset definition failure

Munni
Hi Lev,

is the sample complete
torque_sherry
Hi Lev,

thank you very much for your reply.

This solution works.. but with restrictions. When i put your <Query> in a dataset it works fine (refreshing & executing the query). But i need to insert a parameter in the dataset dialog to request different saleorders than 43661. When i add a parameter 'salesId' with defaultvalue in the dialog, the refreshing button of the designer won't work any more (only the 3 fields diffgr, msdata & xmlns appearing). Executing the query will work.

Perhaps I do something wrong Anyway ... with your solution we can design our reports although it's not perfect.

regards

Patrick
tempicek

Hi Patrick,

The solution is to add default parameter value:

<Query>
<Method Namespace="http://tempuri.org/" Name="GetSalesData">
<Parameters>
<Parameter Name="salesId">
<DefaultValue>43661</DefaultValue>
</Parameter>
</Parameters>
</Method>
<SoapAction>http://tempuri.org/GetSalesData</SoapAction>
<ElementPath IgnoreNamespaces="true">GetSalesDataResponse/GetSalesDataResult/diffgram/SalesData/SalesOrderTable</ElementPath>
</Query>
Henry Habermacher
Hi,

thanks for your reply. I've done that already but it didn't solve the problem.

When running the dataset the result is fine, but when ein refresh the fields list of my query i get the fields: diffgr, msdata & xmlns.

The correct fields only appearing just after dataset creation. but they changing after clicking 'Refresh Fields'.

Other solution for this Perhaps i should post the rdl and webservice code here
throne66957
You can e-mail them to me.
Tygernoot
Please manually define query parameters in the Data Set dialog and give them a default value in that dialog.
Sanjana

That seems like a bug in handling integer parameters.

Try to change salesId on server to string
sParc
Hi Lev,

could you reproduce the error in the sample I've sent you

regards

Patrick
XML DataSource / Designer Dataset definition failure

Answer this question