Displaying Records in Report Builder

If you can sort then, do it DESCENDING and the use a counter and suppress if
over 3.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: Judy Havlik [mailto:judy.havlik@...]
Sent: Tuesday, June 14, 2005 3:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Displaying Records in Report Builder


I need to find a way to display only the last three records on a
report; i.e. there are 20 records that would normally be displayed
based on the filters I have provided but I only want to see records 18,
19 and 20. Does anyone have a suggestion on how to do this?

Sincerely,
Judy Havlik
Plitek, L.L.C.
judy.havlik@...




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
I need to find a way to display only the last three records on a
report; i.e. there are 20 records that would normally be displayed
based on the filters I have provided but I only want to see records 18,
19 and 20. Does anyone have a suggestion on how to do this?

Sincerely,
Judy Havlik
Plitek, L.L.C.
judy.havlik@...
Here's an "out there" method..... (if the linking to other tables is not too extensive)
Create two "alias" tables for the main table and use the "previous" function to link back to one and the previous on that one to link back to the third. Then print them all as lines in a footer on the first one.

Or....maybe easier
Setup a counter and find the max(count)-prepass then have a conditional band line that prints only if count <= max-2.

-Todd C.

-----Original Message-----
From: Judy Havlik [mailto:judy.havlik@...]
Sent: Tuesday, June 14, 2005 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Displaying Records in Report Builder


I need to find a way to display only the last three records on a
report; i.e. there are 20 records that would normally be displayed
based on the filters I have provided but I only want to see records 18,
19 and 20. Does anyone have a suggestion on how to do this?

Sincerely,
Judy Havlik
Plitek, L.L.C.
judy.havlik@...




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]