When using a crosstab with a page break sorting is not working

[Alex1p]

I am trying to sort on a column that is using a page break within a crosstab and for some reason the sort doesn't work. If I remove the page break and have the sort on, the report is sorting correctly. Once I enable the page break, everything becomes out of order. Does anyone have any ideas on how to fix this issue?

[MFGF]

I am trying to sort on a column that is using a page break within a crosstab and for some reason the sort doesn't work. If I remove the page break and have the sort on, the report is sorting correctly. Once I enable the page break, everything becomes out of order. Does anyone have any ideas on how to fix this issue?

How is your page break defined - using a page set? Have you set the "Grouping & sorting" property of the Page Set?

Cheers!

MF.