Thursday, February 16, 2012

Cross tab in crystal 8.5

Hi

I would like to know how to add column headings for the cols created in the Cross tab report in crystal 8.5. Most of the cross tab reports are come with horizontal headings as the fields in the database. If I add a few cols in the cross tab and want to have my own custom headings, how do I do that?. Your help is really appreciated.

thanks

ArunHi

It is difficult to change column heading, because the value of particular field is becoming the heading.
One solution is you can replace column field with a formula. Formula return appropriate value for each data in the field.

e.g

If {PLACE} = "Bombay" Then
"Mumbai"
Else If {PLACE} = "Maddras" Then
"Chenni"
Else
{PLACE}

No comments:

Post a Comment