Replacing column with other column when Data is blank in Crystal report

[former_member309127]

Hi,

I want to replace the Column A with the adjacent Column B if column A data is NULL (dynamically shifting).

For more reference kindly find the attached image

[abhilash_kumar · Accepted solution]

Hi Sailee,

The easiest way to do this is:

1. Insert a new Page header section below Page Header b

2. Copy all contents of Page header b, except the Weight Column, and place them in Page Header c

3. Insert a new Details Section

4. Copy all contents of Details Section a, except Weight Column, and place in Details b

5. Go to the Section Expert > Highlight Page Header b > click the formula button beside Suppress and use this code:

isNull({Weight})

6. Go to the Section Expert > Highlight Page Header c > click the formula button beside Suppress and use this code:

Not isNull({Weight})

7. Use the same formulas as above for Details a and Details b respectively.

Make sure you move the five columns to the left to use the space left behind by the weight column on Page Header c and Details b.

-Abhilash

[former_member309127]

Worked for me... Thank You so much