If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: When using a crosstab with a page break sorting is not working  (Read 399 times)

Offline Alex1p

  • Associate
  • **
  • Join Date: Apr 2022
  • Posts: 4
  • Forum Citizenship: +0/-0
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?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,544
  • Forum Citizenship: +673/-10
  • Cognos Software Muppet
Re: When using a crosstab with a page break sorting is not working
« Reply #1 on: 27 Sep 2022 03:28:20 pm »
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.

Meep!