Supress a date field in cross tab

[saran26]

Hi All,

I have date field in my table called , ClearQuest.testcaseexecuteddate, I included it as a group field in my crosstab report. I have to display the summary fields only when the above field is not null.

I tried this in the supress - as a formula

{ClearQuest.testcaseexecuteddate} <> ""

it is not working and giving me an error saying it requires a datetime field. How to do this ?

CX11.1 version

Please help me out

 

[lbass]

Are you choosing a specific time interval for the datetime field? What is it?

-LB

 

[saran26]

No. I am not.

I am trying to supress it if it doesn't contain any values or it is null.

Thanks

Saran