Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

supress the display when an other field value is null

Status
Not open for further replies.

saran26

Programmer
May 20, 2008
173
US
Hi All,

I have field called date in my table, and an another field called verdict.

I have to supress the date (nothing should be displayed) , if the verdict is null or empty.

How to do that .

Please help me out.

Crystal report version is 11.0

Fields

ClearQuest.rundate
Clearquest.testverdict

Thanks
Saran
 
Hi,
Right-click on the {date} field in your report and, in the format options, check the supress option and the x*2 button to enter this formula:

IsNull({verdict}) or Trim({verdict}) = ""



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top