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?