locked
How to pass parameters to dataset created using xml query RRS feed

  • Question

  • User1426937062 posted

    Hi All,

    I have created a report using an xml, which calls web service method and returns the data in xml format. All i want is that how to pass the parameters to the xml which will get the sepcific data.

    here is the xml to generate dataset

    <Query>
    <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
    <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
    <Parameters>
        <Parameter Name="listName">
           <DefaultValue>My Tasks</DefaultValue>
        </Parameter>
    </Parameters>
    </Method>
    </Query>

    Here I want to pass parameter in place of "My Tasks".

    Friday, June 24, 2011 1:20 AM

Answers

All replies

  • User-1309402178 posted

    hi u can use this code to change with ur parameter

    using System.Xml;

     XmlDocument doc = new XmlDocument();
            doc.Load(Server.MapPath("XMLFile.xml"));
            XmlNodeList ele = doc.GetElementsByTagName("DefaultValue");
            XmlNode node = ele[0] ;
                node.InnerText="newvalue";
            doc.Save(Server.MapPath("XMLFile.xml"));

    if it is helpful mark it as answer

    Friday, June 24, 2011 8:17 AM
  • User1471008070 posted

    Hi,

    To this question of yours, you can refer to this article at Specifying XML Data Using Report Parameters note  http://msdn.microsoft.com/en-us/library/aa964129(SQL.90).aspx 

    For more information about Using XML Data in a Report, please see this tutorial http://msdn.microsoft.com/en-us/library/ms345334.aspx 

    Thanks,
    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, June 26, 2011 11:12 PM