Re: Getting Data From SharePoint

levar — Wed, 08 Oct 2008 07:39:35 GMT

No ideas?

Getting Data From SharePoint

levar — Thu, 18 Sep 2008 09:56:04 GMT

Hello everyone!

Could anyone help me.

I must to build a Payment Report in InfoPath, but I don't know how to get XML data from SharePoint. There is a library at SharePoint witch contain a number of project files (InfoPath XML), every report have a different number of payments - it looks like this:

For project-1:
<Project id="1">
// Here some data
   <Payments>
      <Items>
         <Item ID="1" pData="2008-09-09" pAmmount="15000"/>
         <Item ID="1" pData="2008-03-09" pAmmount="5000"/>
         <Item ID="1" pData="2008-05-09" pAmmount="1000"/>
         <Item ID="1" pData="2008-02-09" pAmmount="150"/>
      </Items>
   </Payments>
</Project>

For Project-2:
<Project id="2">
// Here some data
   <Payments>
      <Items>
         <Item ID="1" pData="2008-09-09" pAmmount="15000"/>
         <Item ID="1" pData="2008-03-09" pAmmount="5000"/>
      </Items>
   </Payments>
</Project>

and so on.

And I need A build a report where all payments will appear grouped by projects. I can't use a Project XML as a Secondary Data source file, because there a number of this files, and I also can't use SharePoint lists because there's a number of payments in each project. As I understand there is a one way - get each project XML and build report in C#, but every time when I try to get file from SharePoint security errors are appearing :(

Is there any way to solve my task?

SharePoint Integration

Re: Getting Data From SharePoint

Getting Data From SharePoint