Head Start for your NPR Report

I have an ABS report that was looping thru the abs.pat.abs.status.x index.

The physical structure for that index looks like this:

?DZS["FINAL",1]
?DZS["IN PROCESS",100]
?DZS["NONE",125]

The report criteria require records where the status is not equal to "FINAL". So the natural thing for some of us is to put this in our page 2 SELECT:

abs.status NE "FINAL"

The problem is, the NPR report writer will loop thru all the "FINAL" records even though it just wants the "IN PROCESS" & "NONE" records in the index.

What you want to do is set your SELECT like this:

abs.status GT "FINAL"

Now the report writer starts looking in the index at the "IN PROCESS" records and skips all the "FINAL" records in that index.

The proof is in the pudding (object code):

IF{"FINAL"'=D(127)}^dzS,
DO{+?DZS[dzS]^dzS&'/R.LIMIT ""^dz,
DO{+?DZS[dzS,dz]^dz&'/R.LIMIT

This approach will not work in all situations; but that's why you are writing the NPR report and its not writing itself.