crosstab and pagination

[eluser]jmadsen[/eluser]
Which par tof the pagination are you having trouble with - the usual rows going on to the next page, or are you trying to move horizontally to a next set of dates? (Or both?)

The way the CI Pagination lib works, you basically rerun the query with a different offset, always with a limit of however many items you want on the page at once. You will also need to get Counts to know how many pages to display in the "menu bar" (i.e., "Previous 2 3 4 Next" links)

Does that get you started, or is it the sql?