Hi , We have developed a Webservice which returns data in the form of xml to client. When we access the webservice from our brower, we were able to see the message with empty string. But in SSRS dataset designing we dont see column at all. For example:- Webservice developed returns the XML data to client.When we bound this webservice has datasource for dataset, we dont see column in dataset which contains empty string or null. How can i have column present in dataset in though XML element value is null or empty. Like DOB in employee xml is sent to client. But this XML contain DOB with empty data like <DOB></DOB>. Since DOB xml element is empty we could not see this DOB column in dataset of Report. How can show tht DOB column in dataset -mahenderMahender

Hi Mahender, By default, SQL Server Reporting Services(SSRS) returns only the columns that contain data while using XML Data Source. If any of the columns is NULL, they are not returned. The solution to fix the issue is using ElementPath in the XML query statement. Maria has offered a detailed solution about this. Thanks Maria! http://blogs.msdn.com/b/mariae/archive/2007/12/13/querying-sharepoint-list-from-reporting-services-returns-only-not-null-columns.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi Jin, Thank you for sharing URL, but the problem Im facing is, my webservice returns Dataset. SOAP XML structure GetMainADRMetaDataSetResponse/GetMainADRMetaDataSetResult/diffgram/MetaData/Table1 Here Table1 is table name. Now table1 contains columns i.e <NewDataset> <Table1> <Column1>Blah</column1> <Column2>Blah2</COlumn2> </Table1> <Table1> <COlumn1>Blah2</Column1> <Column2>Blah3</Columns2> </Table1> </NewDataset> I could able to write Elementpath as per URL u have specified, since it is list collection Currently workaround which i consider is returning of Dummy Row with dummy values and filtering @ row levelMahender