Web Service Dataset with null or empty spaces.
HI, I am using XmlDataDocuments returned by webservices and query in the reports to populate the reports.The issue I have is if the dataset used to populate the XML document has any nulls or empty spaces in any field the whole column or row is missing in the data generated by my query in the Reports. Sometimes the whole data is not being returned to the reports.Sample query I use <Query> <SoapAction>http://xxxx.webservices.org/SelectReportRegisters</SoapAction> <Method Namespace="http://xxxx.webservices.org/" Name="SelectReportRegisters"> <Parameters> <Parameter Name="p_registerType"> <DefaultValue>All</DefaultValue> </Parameter> <Parameter Name="p_registerName"> <DefaultValue>All</DefaultValue> </Parameter> <Parameter Name="p_asOfDate"> <DefaultValue>7-1-2009</DefaultValue> </Parameter> </Parameters> </Method></Query>I have tested the webservice with sample data and it works well, returns data.I use the ISNULL() in my stored procedures to avoid nulls but with empty strings, replacing them with a default value in the managed code is expensive and slows down the reports.Is there some feature I am missing because of which nulls and empty strings are causing this problem.I am using Reporting services 2005.Any pointers will be truly appreciated.
September 6th, 2007 1:26pm

*sigh*I am having the same issue. This was the closest google match I could find, alas, no answer.
Free Windows Admin Tool Kit Click here and download it now
January 14th, 2009 3:02pm

Friends, I encountered the same problem and finally figured (atleast in my case) that the inputs parameters from SQL Reports into webservice are case sensitive and once I matched them in both places, it worked fine.
May 26th, 2012 2:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics