Report Builder- opposite of PREVIOUS(field) is?

One trick that I use is a counter. Create a counter for each line. If you are using groups, make sure it resets when it needs to. Make sure the counter does a prepass first than you can use an X +1 ideology to pick the next line.

Jasper

-----Original Message-----
From: Carol Engen [mailto:cengen@...]
Sent: Wednesday, September 14, 2005 5:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder- opposite of PREVIOUS(field) is
???


I found a work-around...change a sort to Descending Order (water cooler
talk goes a long way)

Thanks for your reply!

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of pjw@...
Sent: Wednesday, September 14, 2005 3:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder- opposite of PREVIOUS(field) is
???

There is no NEXT() command.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Carol Engen
Sent: Wednesday, September 14, 2005 3:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder- opposite of PREVIOUS(field) is ???

The PREVIOUS(field) works, however, I am not finding a NEXT(field) in
the
canned formulas. Am I missing something?



(I am working with the VendPart, VendPBrk tables to get a range on the
quantity. The table only provides the minimum...the maximum would be at
the
next level.)





Thank you,





Carol Engen

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 Links
The PREVIOUS(field) works, however, I am not finding a NEXT(field) in
the canned formulas. Am I missing something?



(I am working with the VendPart, VendPBrk tables to get a range on the
quantity. The table only provides the minimum...the maximum would be at
the next level.)





Thank you,





Carol Engen

Winona Lighting
Phone: 507-454-5113, Ext 314
Fax: 507-454-4806

e-mail: cengen@... <mailto:cengen@...>





[Non-text portions of this message have been removed]
There is no NEXT() command.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Carol Engen
Sent: Wednesday, September 14, 2005 3:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder- opposite of PREVIOUS(field) is ???

The PREVIOUS(field) works, however, I am not finding a NEXT(field) in the
canned formulas. Am I missing something?



(I am working with the VendPart, VendPBrk tables to get a range on the
quantity. The table only provides the minimum...the maximum would be at the
next level.)





Thank you,





Carol Engen

Winona Lighting
Phone: 507-454-5113, Ext 314
Fax: 507-454-4806

e-mail: cengen@... <mailto:cengen@...>





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



------------------------ Yahoo! Groups Sponsor --------------------~--> Fair
play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->

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 found a work-around...change a sort to Descending Order (water cooler
talk goes a long way)

Thanks for your reply!

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of pjw@...
Sent: Wednesday, September 14, 2005 3:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder- opposite of PREVIOUS(field) is
???

There is no NEXT() command.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Carol Engen
Sent: Wednesday, September 14, 2005 3:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder- opposite of PREVIOUS(field) is ???

The PREVIOUS(field) works, however, I am not finding a NEXT(field) in
the
canned formulas. Am I missing something?



(I am working with the VendPart, VendPBrk tables to get a range on the
quantity. The table only provides the minimum...the maximum would be at
the
next level.)





Thank you,





Carol Engen

Winona Lighting
Phone: 507-454-5113, Ext 314
Fax: 507-454-4806

e-mail: cengen@... <mailto:cengen@...>
I think you can sort/group on an alias of the same table linked by the previous key values and then use the "regular" table as a "look ahead" or next version. This might be tricky though (depending on how smart RB is) if the sorting/grouping is not the same as the primary index you are linking on. If I recall correctly I did this once upon a time to "peek ahead" and anticipate a grouping change in order to condition some band lines.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Carol Engen
Sent: Wednesday, September 14, 2005 3:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder- opposite of PREVIOUS(field) is ???


The PREVIOUS(field) works, however, I am not finding a NEXT(field) in
the canned formulas. Am I missing something?



(I am working with the VendPart, VendPBrk tables to get a range on the
quantity. The table only provides the minimum...the maximum would be at
the next level.)





Thank you,





Carol Engen

Winona Lighting
Phone: 507-454-5113, Ext 314
Fax: 507-454-4806

e-mail: cengen@... <mailto:cengen@...>





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



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



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]