paging in jasper report viewer

Hi there,

i am connecting to Mysql database in order to retrieve data. what if i have 1 million records in the DB. how does jasperviewer deal with this? does it retrieve all at once or retrieve page by page according to user selection of the next button. i noe crystal report supports paging so that each time the user click go to next page, it is going to retireve the data from the database.

Does JasperViewer support paging-on-demand? coz if it doesn't, my computer is going to run out of memory if i retrieve extremely large records. And can you suggest any methods to get around the paging problem if JasperViewer doesn't support it? Any ideas or suggestion is greatly appreciated.

regards,
Chris