cross tab expand to multiple page

[fsreport]

Hi All
cr 9.0
ms sql
i have a cross tab and with a start date and end date
if the user select 12 months it expands more than one page
how can i limit to 12 months per page and the rest on the next page

thanks

pg

fsreport

 

[fsreport]

fix it

fsreport

 

[Fabix]

Hi pg,

If could share your solution that would be great.
I have the same exact problem

Thanks

 

[fsreport]

hi
creetd a group base ona formula quater
so display 3 months per page and does not expand on a second page
@Qtr_Page
If (DatePart("q", {TRANSACTION_HISTORY.POSTING_DATE})) =1 then "QT1"
else
If (DatePart("q", {TRANSACTION_HISTORY.POSTING_DATE})) = 2 then "QT2"
else
If (DatePart("q", {TRANSACTION_HISTORY.POSTING_DATE})) =3 then "QT3"
else
If (DatePart("q", {TRANSACTION_HISTORY.POSTING_DATE})) =4 then "QT4"

fsreport

 

[fsreport]

then move my cross tab in tha goup section and works fine

fsreport

 

[Fabix]

Great. Thanks a lot!