Last 10...

Is there a function that I can use to limit the result set in a report to the last 10 entries? I only want to show the ten most recent results entered. Any advice is appreciated. Thanks


Listserv Archives (BOB member since 2002-06-25)

In a message dated 98-11-12 19:14:41 EST, you write:

Is there a function that I can use to limit the result set in a report to
the last 10 entries? I only want to show the ten most recent results entered. Any advice is appreciated. Thanks

One thing to try would be to do a descending sort on “entry date” or other appropriate object on the query panel. Using the OPTIONS button, select 10 rows. Note that you must do both of these… one without the other will not work.

Then on the report, override the descending sort with an ascending sort if you want things in chronological order.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com


Listserv Archives (BOB member since 2002-06-25)

Thanks, that worked awesome. Bummer that it shows the partial results flag but that is minor. Thanks for the tip!

From: DRathbun@AOL.COM[SMTP:DRathbun@AOL.COM]
Sent: Thursday, November 12, 1998 7:38 PM

In a message dated 98-11-12 19:14:41 EST, you write:

Is there a function that I can use to limit the result set in a report
to
the last 10 entries? I only want to show the ten most recent results entered. Any advice is appreciated. Thanks

One thing to try would be to do a descending sort on “entry date” or other appropriate object on the query panel. Using the OPTIONS button, select 10 rows. Note that you must do both of these… one without the other will not
work.

Then on the report, override the descending sort with an ascending sort if you
want things in chronological order.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (9am-5pm ET only): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’


Listserv Archives (BOB member since 2002-06-25)