Order and Group in InfoPath

[PeterNZ]

This is the Scenario:
We have an XML with Element A which is MinOccurs 1 and MaxOccurs unbound.
Somewhere in the Structure of this Element we have a Criteria (a child
element) which can have the Values X,Y and Z.

In an InfoPath Form we want to have a Table view which shows the data of
Element A in rows grouped and sorted by the Criteria i.e. 3 rows of Elements
with Criteria X, 4 rows with Criteria Y and 1 row with Criteria Z.

The way I tried to solve this was with three different Repeating Sections
which pointed to the same Element. Obviously InfoPath doesn't like this. But
I ignored the warning and tried it anyway. I added a conditional formatting
based on the Criteria. First repeating section had "If criteria equals X hide
this control". You get the picture.

What I got was Infopath showing multiple rows (for each occurence one row)
but always with the data of the first element. I assume that's because I have
three repeating sections pointing to one Element in the Schema.

Does anyone have an idea how you can do something like this in InfoPath? I
can't change the XML Schema as it comes from a Web Service.

I am a bit frustrated, so please cheer me up a bit.

Cheers & Thanx

Peter

 

[ScottD[Interlink Group]]

Peter, I would recommend you take a look at the asset tracking sample in
InfoPath. This form includes the abiltiy to sort the listed assets in the
table by selecting one of the columns from a dropdown and clicking the Sort
button. I think this will give you some good ideas.