I have a table with two numeric columns (A, B). Column B is a calculation on Column A (fixed amount - Col A). I want the report to display by highest A until B reaches zero, but, at minimum, I want to display 15 rows. In other words, if the value of Col B on the 5th row is zero, then I want to continue displaying rows until I have a total of 15 rows on the report.
If Col B doesn't get to zero until the 30th row, then I want to display all 30 rows. Can this be done?

This message has been edited. Last edited by: Ted Michalski,

Sure.
You could compute an extra field in your table that keeps track of the record number (just increasing the value by one for every new record). And then have a second compute with which you define if the record should be printed or not using the newly created recordnumber and the value of the B column to decide. So something like this should do the trick:

TABLE FILE ...
COMPUTE RECNO/I5 = RECNO+1; NOPRINT
COMPUTE PRINT/A1 = IF RECNO LE 15 THEN 'Y' ELSE IF COLB GE 0 THEN 'Y' ELSE 'N'; NOPRINT
....
WHERE TOTAL PRINT EQ 'Y';

Thanks GamP. This works.

GamP, is there any way if the number of rows goes past 15 before I reach zero, to display all the rows that are not zero AND the first row that is zero?

Ted, this is all to do with flagging records, then filtering.

If you have the logic to flag the record, the you can keep it.

For example:

IF LAST COLB GT 0 AND COLB EQ 0 THEN 'Y' ELSE ...