I am working on creating Crystal Reports from a DB2 database.

In CR you can define a multiple range parameter i.e. 1-10, 100-200, 300-400 and Cr will filer records that satisfy this criteria.

How can I transfer this functionality using a stored procedure?

You just need to limit the number of rows returned? If so, add "fetch first n rows only" to the end of your sql.