I have a script which works great except for one feature of it.

I am trying to omit all but the first record in the found set but its not working too well.

Nothing stands out for me as to what I am missing in the script area (see "Omit all but the first record" in the attachment)

wps_ZipCode.pdf

Why not go at from the other direction. Omit the first record, then show omited.

The steps would look something like:

Find All

Omit (you need to be on the record you want to isolate)

Show Omitted

Lee

thanks, i will try it.

After looking at the script again based on you guys feedback, I believe that is what i have coded in my script.

Is one of my statements wrong?

You could also go to the second record, then use the Omit Multiple Records script step. Have it omit the following formula:

Get ( FoundCount ) - 1

Edited June 15, 200718 yr by Guest