Crystal Report Formula Editor.

[abhijit]

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

[ducky]

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.

[abhijit]

Hi Ducky,
I tried doing it.

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.

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

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

[brucevde]

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" )