I need to do a formula field "@DateDoc".
First, I will check the field (Date_Doc), If it's empty, then the @DateDoc will display "-", Else if the field contain value, then I will display the Value of the field.
------------------------------------------------------
If {WOS.Date_Doc} = "" Then
{@DateDoc} = "-"
Else
{@DateDoc} = {WOS.Date_Doc}
End If
-------------------------------------------------------
But there's an error occurred :
"A statement expected!"

Please assist.

Thanks.

Hi Winnie,

If you are using Basic Syntax you can do this

If {WOS.Date_Doc} = "" Then
 formula = "-"
Else
 formula = {WOS.Date_Doc}
End If

And if you're using Crystal Syntax simply omit the word "formula"
and "end if"


If {WOS.Date_Doc} = "" Then
   "-"
Else
   {WOS.Date_Doc}


-Dhodie

thanks.

basic syntax:
I tried both codes :-

If {WOS.Date_Doc} = "" Then
 formula = "-"
Else
 formula = {WOS.Date_Doc}
End If

cyristal syntax:
If {WOS.Date_Doc} = "" Then
   "-"
Else
   {WOS.Date_Doc}

ERROR :
-------

"A Date-Time is required here"

Hi winnie!

Sorry i didnt noticed that you are using Date Field
In your code you are trying to compare a date field to an empty string that's why you have encountered "A Date-Time is required here" error. If you're checking if {WOS.Date_Doc} is null try changing your code to this

crystal syntax

If IsNull( {WOS.Date_Doc}) Then
   "-"
Else
  Cstr({WOS.Date_Doc})

Notice that i converted {WOS.Date_Doc} to string by using the Cstr function to make the returning value same in data type.

-Dhodie

Thanks a lot! :)
Will ask u again if there's any problem

Have a wonderful day :)

Hi Dhodie,

Can I control the fdatabase field and if the value is null or "" then it's = "-" instead of using formula field?
How can I control it?
there's a few options :-
-Suppress
-keep object
-close border on page break
-can grow
suppress if duplicated

-Winnie

If you are connecting to SQL Server you can have the null
values replace by any values that you choose. In this case "-"
ex.
ISNULL(check_expression, replacement_value)

If you have a query like "Select {WOS.Date_Doc} from SampleTable"
you can change it to "Select IsNull({WOS.Date_Doc},'-') from SampleTable". This will replace all null values of your query to "-".


-Dhodie

If you are connecting to SQL Server you can have the null
values replace by any values that you choose. In this case "-"
ex.
ISNULL(check_expression, replacement_value)

If you have a query like "Select {WOS.Date_Doc} from SampleTable"
you can change it to "Select IsNull({WOS.Date_Doc},'-') from SampleTable". This will replace all null values of your query to "-".


-Dhodie

----------------

Thanks.
I'm using ado.net to connect. the "Select IsNull({WOS.Date_Doc},'-')"
is used at the field database in the crystal report? or in the sql query?

Do it in SQL Query

-Dhodie

Thanks.

for the formula :

If IsNull({WOS.Date_Sum}) Then
   "-"
Else
  Cstr({WOS.Date_Sum})

Result value = eg. 18/08/2001 00:00:00

How can I convert it to value eg. 18/08/2001 or 18-Aug-2001 ??
Thanks.