InfoPath Dev

Hello,

I am attempting to filter data from a secondary data connection into a repeating table. I am able to query the DC and bind the results to a repeating table. However, I need to filter out certain results..

Below is an example of what I am looking to accomplish...


Title | Location | Column 1 | Column 2 | Column 3|
__________________________________________________
title1 | USA | Yes | No | No
title2 | Mexico | No | Yes | No
title3 | Canada | No | No | No
title4 | USA | Yes | No | No
title5 | Italy | Yes | No | No
title6 | France | No | No | No

Above is a basic query to the DC for data. The query is blank and returns all results into a repeating table. I want filter all instances of 'Yes' into a table and leave out all 'No's.

E.G.: Since Canada and France have only No's they are filtered out.

Title | Location | Column 1 | Column 2 | Column 3|
__________________________________________________
title1 | USA | Yes | No | No
title2 | Mexico | No | Yes | No
title4 | USA | Yes | No | No
title5 | Italy | Yes | No | No


I know an option would be to separately query columns 1-3 but that would require 3 different queries, 3 data connections, and 3 tables.

Would it be possible to do this by using the Eval function? Or creating a local table on the form itself have it pull data that contains 'yes'?


Thank you in advance for any help.

 It's actually much easier: just add a formatting rule to your repeating section. Set the rule condition to be "Column1 = No AND Column2 = No AND Column 3 = No" and then check the "Hide this control" checkbox.  This will hide all rows that have No for all three columns.

I'm not sure if I fully understand..


I am not able to set any other rules than an action.

I am able to bind the data to a table, and query for results. However to do what I am looking to do would be a good number of queries along with connections.