RB: Opposite of PREVIOUS(field)?

Really a blind stab, off of the cuff suggestion....
- Create an alias version of APInvoice and use the Previous to link to it (looking back so to speak) then (if RB allows this) sort on the aliased and use that as your primary pass table and when needed look at the main table as the "next". One caution...if this works performance will be poor. I have a hunch though this might violate something in RB but it might be worth trying.
-Todd C.

-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Friday, October 15, 2004 11:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Opposite of PREVIOUS(field) ?


I have repeating records due to a one-to-many-ratio and I want to attempt to
use the Conditional Print to suppress them. I am able to get a '?' using
PREVIOUS(field), but since this is on APInvoice, I would like to attempt
using the opposite of this formula to get the records to appears after the
last APInvoiceLine. I am not seeing a canned formula and NEXT(field) does
not work.

{creating a report for invoice review, which has a bigger font than the
Vantage-provided, as well as additional fields from what they provide}

Table links include APInvHead, APInvLine, APExp, APInvMisc, Vendor, Terms...

...My pet peeve that those of us over 40 must try to read the Vantage canned
reports for any reason.


Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@... <mailto:cengen@...>


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 Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129f0va3u/M=315388.5500238.6578046.3001176/D=groups/S=1705007183:HM/EXP=1097943595/A=2372354/R=0/SIG=12id813k2/*https://www.orchardbank.com/hcs/hcsapplication?pf=PLApply&media=EMYHNL40F21004SS> click here
<http://us.adserver.yahoo.com/l?M=315388.5500238.6578046.3001176/D=groups/S=:HM/A=2372354/rand=296206393>


_____

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]
I have repeating records due to a one-to-many-ratio and I want to attempt to
use the Conditional Print to suppress them. I am able to get a '?' using
PREVIOUS(field), but since this is on APInvoice, I would like to attempt
using the opposite of this formula to get the records to appears after the
last APInvoiceLine. I am not seeing a canned formula and NEXT(field) does
not work.

{creating a report for invoice review, which has a bigger font than the
Vantage-provided, as well as additional fields from what they provide}

Table links include APInvHead, APInvLine, APExp, APInvMisc, Vendor, Terms...

...My pet peeve that those of us over 40 must try to read the Vantage canned
reports for any reason.


Thank you,

Carol Engen
Controller
Winona Lighting
Phone: 507-454-5113, Ext. 314
Fax: 507-454-4806
e-mail: cengen@... <mailto:cengen@...>