Cross Tab

[Kaushik1975]

Hello
Is there a way by which u can restrict number of columns that come on cross tab. I have a problem that it does not fit in one page so i would like that to continue on the next page


Bye

 

[kenhamady]

You can use a formula field that creates two values from your column field, somethinng like:

If {field} > "M"
then "Group 1"
else "Group 2"

Create a group in your report on this field and place the Cross-tab in the Group Header. It will split into two pieces. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.