Filter repeating table for a date range or last 5 records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John S. - 24 Jan 2006 00:44 GMT

Hello,

I want to know if it is possible to filter a repeating table to show only
records between a specific date range and also to show only 5 of the latest
records. Any help is appreciated.

Thanks

Reply to this Message

Bojana Marjanovic [MSFT] - 24 Jan 2006 01:24 GMT

Hi John,

You can filter a repeating table to show only certain records by setting
some conditional formatting on the table itself (not one of the fields
within the table). You should be able to easily set the conditions for the
specific date range and then enable the 'Hide this control' checkbox.

As for showing only the five latest records, that will require some code.
You'll have to make sure that the XML is sorted by date and then show the
last five instances.

-Bojana

> Hello,
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Albator - 24 Jan 2006 07:54 GMT

Hi,

For complete the answer of Bojana:

If your repeating table is a main dataource you can in properties of
the section (display tab) filter data.

this feature is only possible for a main datasource. So if you use a
secondary datasource you need to make a filter before that enter in
infopath or by code like say Bojana

Thierry

Reply to this Message

John S. - 24 Jan 2006 16:30 GMT

Thanks for the quick replies, but I cannot filter the records for a date
range (e.g today() - 10 does not work).

> Hi,
>
[quoted text clipped - 8 lines]
>
> Thierry

Reply to this Message