Skip to Content
0
Former Member
Jan 10, 2008 at 04:30 PM

Show / Hide fields in Crystal 11

48 Views

Post Author: djhc50

CA Forum: Formula

I am in need of some help in the "if-Then-Else" world of Crystal 11, and being a newbie, am largely unfamiliar with the syntax. Basically, I have a situation where I need to display the current date and time on the report if a particular database field is blank, or else, display a future date that exists in a different database field. For example, the database field in question is {tablename.dbfield} and the other database field name that houses the future date is {tablename.futuredbfield}. Will the code look something like?:If {tablename.dbfield} = ' ' Then Print Date else {tablename.futuredbfield} Any help getting my ridiculous english/crystal hybrid code into something that may actually function would be greatly appreciated. Thanks in advance,DJH