Crystal Report Formula Editor.

Hi,
I have a nullable datefield being retrieved from a sqlserver table.
I wish to put in a formula which checks if the field is null and if null, print "Not Authorised" in the report.

How do I write a formula?

Another question on Crystal Reports...
How do i have multiple ifs in one single formula?

Cheers!
Abhijit

If your creating the formula in the designer, then click formula in the field explorer, then click new. Give the new formula a name. Then create your fomula like...

if isnull({TABLE.FIELD) then "Not Authorised"
else {TABLE.FIELD}

As for multiple if's, thats ok. Just use standard vb if-then-else structure in your formulas. Check the help files in the designer and it will explain the syntax of the formula editor.

Hi Ducky,
I tried doing it.

Code:

---

if isnull({UserDefTable.CreatedDateTime}) then "UnAuthorised"

---

However the error message that I get is
The formula result must be a boolean.
So I changed it to this.

Code:

---

if isnull({UserDefTable.CreatedDateTime}) then "UnAuthorised"
else {UserDefTable.CreatedDateTime}

---

This caused another error "A String is required here".
So I further changed my code to

Code:

---

if isnull({UserDefTable.CreatedDateTime})
    then "UnAuthorised Access"
else "Allowed To DO It"

---

This is causing the same error as before. I am using SQL Server 2000. Can I use something to convert this datevalue to a string in the formula editor?

Help,
Abhijit

A Formula cannot return different datatypes.

Use the ToText or CStr functions to convert dates, numbers etc to strings.

if isnull({UserDefTable.CreatedDateTime}) then "UnAuthorised"
else ToText({UserDefTable.CreatedDateTime}, "dd-MMMM-yyyy" )