limit cross tab collumn per page 1

[Durango122]

Hi All
cr 9.0
ms qsl
i created a cross tab and it has parameter start date and end date
my cross report by month base on my posting_date
i have something like this

here is a sample of my report layout

****************** Jan 2006 Feb 2006
******************-------------------|----------------
Definition|UserName| MF|529|VIT|TOTAL|MF|529|VIT|TOTAL
Central |Summers |2 | 1 | 1 | 4 |1 | 2 | 5 | 8


jan 2006 and feb 2006 are my collumn heading

i can place 3 wide per page
ex:
jan 2006 | feb 2006 | mar 2006 |
but if the select more than 3 months it expand out of my page range

how can i get new page base apond the date range

thank you








Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Madawc]

You could group by quarters and put the crosstab in the quarter group footer.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Durango122]

Hi
how can i group by quarter
i have a gr1 call definition

?????????????????????
thanks



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Madawc]

ToText(DatePart ("yyyy", {date1}) & "/" & ToText(DatePart ("q", {date1})

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10