Is it possible to make Microsoft Reports component use server side paging when displaying data.
I had problems in the past with getting all the data from the database and then having client side paging implemented. large amounts of data were triggering out of memory exceptions on the server.
So basically what I want is to use Microsoft Reports for my reports and to make sure it only pulls data that are actually shown on the page from the database.
Is this possible with Microsoft Reports?