Can Grow for Cross Tabs?

[lovevthokie]

I have a memo field as a row in my cross tab. I will never know how long it can be and I need the field in the cross tab to lengthen to fit the entire field. The Can Grow Option is greyed out and I can't seem to find another way to get the box to grow. Right now it will just cut off all text after 2 lines since that is the current size I have it at. I don't want to make the box really big since the field could be 2 words and I don't want a lot of white space therefore I need this to be sized to fit!

Thanks in advance for any helpful ideas!

 

[kenhamady]

I can't think of a way using true cross-tabs.

You could use a "manual" cross-tab. This is described in my FAQ on common formulas. But it requires that the columns be hard coded. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[lovevthokie]

Thanks but I had already checked out the manual way and I will never know how many columns will exist for one report which is why I had to go with true cross-tabs. Can I create a manual cross tab with a dynamic number of columns?

 

[kenhamady]

I don't know of a way.

I am also surprised that you can even use a memo field in your Cross-tab. I can't. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[lovevthokie]

Actually that was my mistake in typing and looking at my fields! I meant to say 255 length Text field. That makes it better then having the memo in there. Regardless, it won't let me size to fit. I have decided to just allow white space there and hope that the client doesn't mind it too much! Thanks anyways for your help!