Button to show all records?
In a paginated results set, how would I add a button that would give the user the choice to display all records? Reason I ask is that I'm also giving them the option of exporting the table to Excel but it will only export the page of results it's on, so I need to be able to provide the option of showing all records. Don't want to make this this default view though as there are over 3,000 records and rising daily!