Split columns in cross tab 1

[neskin]

Hi ,
In crystal XI how can I split columns in cross tab. I am not able to fit across the page all columns .How can I show first 13 and then another 20
1 2 3 4 5 6 7....


14 15 16 17 18 19 20 ...

thank you in advance
Nat

 

[neskin]

I have created formula for column
if {SPCRYRPT_SANADNLQUARTER.RMTID} in 1 to 13 then "RMT" & totext({SPCRYRPT_SANADNLQUARTER.RMTID},"###")
but it is still show me the column of remaining total of 14 to 20
How to suppress or exclude the column

thanks in advance
Nat

 

[lbass]

If your ID field is sequential, then create a formula:

if {SPCRYRPT_SANADNLQUARTER.RMTID} in 1 to 13 then 1 else
if {SPCRYRPT_SANADNLQUARTER.RMTID} in 14 to 26 then 2 else
if {SPCRYRPT_SANADNLQUARTER.RMTID} in 27 to 39 then 3 else //etc.
4

Insert a group on this formula and then place your crosstab in the group header or footer and suppress the detail section.

-LB

 

[neskin]

thank you.That worked for me.