Posted by: R Manimaran | September 15, 2008

Changing the Display string of Column in Crystal Report Cross – Tab

There may be a situation where we need to modify the Column Title display string.
We can change the Column title using the Display string in the Format Field option.

Select the Column Title in the Cross-tab. Right click and select Format Field option. Under the Common Tab select the Display string x-2 button.

Use the GridRowColumnValue function in the condition statement
i.e.
if GridRowColumnValue(“TableName.ColumnName”)=”string to Check” then
“New Disp String”
Else if GridRowColumnValue(“TableName.ColumnName”)=”string to Check” then
“New Disp String2”

Advertisements

Responses

  1. Thanks a lot!!!

  2. Could you tell me how to change a string variable at crystal report into a pattern such like this :

    1001000100 change the display to be like this 100.100.01.00

    thanks


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: