PB version 9.0.2 and database

I need to sort my dynamic crosstab by a field that is in a column heading
(enc_date) but is not in the row. I am getting the data I need for the
crosstab via a stored procedure that uses union all. I also need to limit
the number of dynamic columns per page, or designate columns to repeat on
the next page.

Attached is my crosstab, in case a visual helps. Any suggestions on what I
should do?

Thanks
Loya