I have a requirement to create a report which displays every Nth record, where N is a user supplied number), which meets the search criteria and I'm having a difficult time figuring this out. Creating the initial result set is no problem, but how do I display say only every 100th record from within that result set?

Thank you.

This message has been edited. Last edited by: BGronli,

SUM
...
COMPUTE ROWCOUNTER/I11 = IF ROWCOUNTER LT 100 THEN ROWCOUNTER+1 ELSE 1;
...
WHERE TOTAL ROWCOUNTER EQ 100;
...
END

g'luck

Thanks Dave. That is what I needed, with a little tweaking. For me, I needed to create the result set without the BY statements and then display the result set using the BY statements. Otherwise, it limited the result set too much because the output is going to Excel and is using BYTOC.