Skip to Content
0
Former Member
Nov 15, 2012 at 11:19 AM

How to handle blank values in crystal report.

408 Views

Hi,

I have a crystal report, i need to check whther a column A is blank or not. if it is blank then i need to create a formula like this:

If (ColA=blank,ColB,ColC).

i am using IIF condition in the crystal report, but when i am trying to compare Col A with blank value it is throwing error.

i am doing something like this:

IIF(ColA='',Clob,ColC)

can anybody please tell me how to handle blank values in crystal report?