Rlist statement (AREV Specific)
At 10 JUN 1998 04:34:42PM Bruce Lee wrote:
I have a report that builds an Rlist statement to display inventory transactions by inventory code, by inventory transactions date. Is there a way to display only the last transaction of each break-on group of inventory items, instead of all inventory items within each group. For example, now the report lists 100 transactions for a given inventory item, I would like to only see the 100th transaction.
Thanks Bruce L.
At 10 JUN 1998 05:00PM Dana Corson wrote:
Maybe this will help. I am guessing that you do not want to go down to the bottom of the output list on your screen.
Sort the list descending and the latest will be on the top.
At 10 JUN 1998 05:21PM Jeff Blinn wrote:
I have a report that builds an Rlist statement to display inventory transactions by inventory code, by inventory transactions date. Is there a way to display only the last transaction of each break-on group of inventory items, instead of all inventory items within each group. For example, now the report lists 100 transactions for a given inventory item, I would like to only see the 100th transaction.
If you're adding numbers, and you only want to see the totals/subtotals that are displayed at the break point, you can add the DET-SUPP (detail suppress) switch to the list statement. This will only display the 'break lines' (different than the last line of detail).
Jeff
At 10 JUN 1998 05:38PM Andrew P McAuley wrote:
You can also see the break on value instead of *** by putting a V in the break-on clause i.e.
Break-on Whatever "Value is 'V'"amcauley@sprezzatura.com
World Leaders in all things RevSoft
