COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Alex1p on 27 Sep 2022 09:44:52 AM

Title: When using a crosstab with a page break sorting is not working
Post by: Alex1p on 27 Sep 2022 09:44:52 AM
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?
Title: Re: When using a crosstab with a page break sorting is not working
Post by: MFGF on 27 Sep 2022 03:28:20 PM
Quote from: Alex1p on 27 Sep 2022 09:44:52 AM
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.