if and else condition with date in crystal report

Question

if and else condition with date in crystal report

Navigation

#1 by (0 votes)

1

I'm performing a condition in my report to insert "-" when the Due date is null, but an error occurs when the date comes other than null. Below is the image that shows the error when filling in the due date:

Thefollowingexpressionwasusedinthereportreport:

=IIf(Fields!DataVencimentoPago.Value<>"",Format(Fields!DataVencimentoPago.Value,"dd/MM/yyyy"),"-")

I tried it in another way, but without success:

=IIf(Fields!DataVencimentoPago.Value <> "", Fields!DataVencimentoPago.Value,"-")

.net crystal-reports

asked by anonymous 29.06.2018 / 15:34

1 answer

Length of field occupies total value defined? Return of the maximum value

score 0 · Answer 1

Identified the problem the component used that report does not accept null values in the field, so the following change was made:

29.06.2018 / 16:31