Need to allow paging and exporting

I've got a .NET web app that has a report, and every time I click the paging or export button, the report refreshes to the parameter prompt. Same thing with clicking on the group tree.

I'm using version XI.

I've got the DB credentials fine, since my two Crystal XI books tell me how to do that...but I haven't found anything about paging and exporting.

Thanks!Duh...had to use:

If not page.ispostback....

thanks!sql

Need SQL to perform Repeater paging

I want to build some paging functionality into my repeater (b4 you ask, datagrid not providing flexibility required for presentation).

I will have no problem with the VB logic but I will need to execute SQL that only returns results from x to y (e.g. results 21 thru 40 for page 2). I know I can do something like 'SELECT TOP 20 * FROM...', or something like it, for page 1. But, I'm not sure if it's possible to build SQL for the pages greater than 1. Any suggestions.

Thanks
MartinSorry to waste your time, I found a solutionhere.

Thanks anyway,
Martin