Wednesday, October 18, 2006 5:34 AM
by
bsandeman
Repeating Lines/sections and choosing a row
This is a handy little thing that I have discovered today....
It is possible to display on a view a repeating table/section twice(or more if you so wish), such that the first one displays all lines and then the other one displays a restricted list of lines.
This is done by using conditional formatting on the second set such that it only displays the lines that you wish to see.
I have used this so that I actually have my repeating groups on different views. On my first view I have a repeating table showing all lines. Then on my other view I have a repeating section which displays many more fields for my line but only the line that user clicked a button on.
To do this you must set a field in the schema to contain the value of the formula count(preceding-sibling::*) when the button is clicked. Then on the other one use conditional formatting to hide when this field is not equal to count(preceding-sibling::*).
very useful :-)
It is worth noting that this is demonstrated in the Expense Report sample provided with InfoPath.