Omit all but the first record

[shawnj985]

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

[AudioFreak]

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

[Lee Smith]

The steps would look something like:

Find All

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

Show Omitted

Lee

[shawnj985]

thanks, i will try it.

[shawnj985]

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?

[Paul Spafford]

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, 2007 by Guest