cross tabs naming coloum problem

[coffee123]

greetings

I have an intresting problem. I have a cross tab table. I have the dates in the coloum headings. But i need to put a changing text under the dates. eg

headings =====> 07/07/02 14/07/02 etc ....
changing text =====> Period 1 Period 2 etc .... Period 12

I have tried to change it in the group section with the use of a formula but it only repeats the first text.

any suggestions?

thanks
coffee123

 

[kenhamady]

How about using a formula that concatenates the date, a carriage return and a your text. Something Like:

Totext(Date) + CHR(13) + "Period " + {@period} Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[coffee123]

cheers mate your idea helped. It made me look at the problem at a different angle.

thanks

Kevin