Re: Showing items count from Form Library in a repeating table

Shivh — Wed, 08 Sep 2010 05:43:07 GMT

I have managed to solve the issue.

Thank you.

Showing items count from Form Library in a repeating table

Shivh — Tue, 07 Sep 2010 10:38:17 GMT

Hi Everyone,

Greetings for the day.

I have designed an Infopath form which collects data to create new request for each department. This form data is saved in Forms Library of SharePoint using Data connection. Then Approval/ Rejection happens for the workflow started. All is well. Now I have to show report, once user goes to the Report section.

The report will show Department Name in left most column, Number of requests(i.e. Count of rows where 'Department Name' is XYZ) for that department next to it, Number of requests Approved(count of rows where Status is 'Approved' and Department name is 'XYZ'), Number of requests Rejected etc in adjacent columns. I have created a data connection to receive data from the Forms library. This connection shows all the data when I bind it to a repeating table. I tried to set rules in Tools>Form Options>Open and Save but it does not show what I want.

I am back to square one while doing this which is no where. One more consideration is that I can't use code for this, Only Rules and Actions. Is this possible? If yes, can you please guide me to achieve this?

Appreciate your help. Below is the dummy look n feel of how the report should look alike:

Department Name	Request submitted	Approved	Rejected	Pending
Operations	10	5	4	1
Marketing	15	10	3	2
Resourcing	6	2	3	1

SharePoint Integration

Re: Showing items count from Form Library in a repeating table

Showing items count from Form Library in a repeating table