Plaese Help urgently"using isNull function is not working plaese post correct format

[anwar zaman]

Hi dear

i am generating a report in CR 8.0 my requirement is check a datefield (deliveryNoteDate) if its Null then its show a messsage "UnDelivered"

else if its not Null then show message "delivered"

Report format

Item status
------- -------
abc delivered '(Here DeliveryNoteDate is not NULL)
cfrd undelivered '(Here DeliveryNoteDate is NULL)


Please anyone expert in CR8.0 help.

Thanks in advance

[RobDog888]

I assume the datefield is a checkbox in an Access db? If it is then it will never be nul as it will be checked or unchecked (0, -1).

[anwar zaman]

Rob Thanks for replying


and the database i am using is not Acess its on Oracle 8i & its datatype is Date

More u know i am creating two repots one is for example

1)Vehicles Delivered Report
=====================

Vehicles Status
======= ========
coure Delivered
altis Delivered
Gli Delivered

2)Vehicles UN-Delivered Report
========================


Vehicles Status
======= ========
coure UnDelivered
altis UnDelivered
Gli UnDelivered

so when i made the first report Delivered Report
i use the following condition & its works

Code looks like
============

formula name=@chk

dim strV as string
if Not isnull({VEHICLEDETAILS.DELIVERYNOTEDATE}) then
strV = "Vehicle Delivered"
end if
formula = strV
this code works & generating the reports
=============================

but in other report Vehicles Undelivered report i am using below code but its didnt displayed my required message


dim strV as string
if isnull({VEHICLEDETAILS.DELIVERYNOTEDATE}) then
strV = "Vehicle Not Delivered"
end if
formula = strV
=====================================


I think now it wud be easy for u to give me appropriate solution

Thanks for ur care & quick reply

i will be waiting for ur reply plaese do reply as soon as posible

sincerely urs
anwar zaman
Manger IT
TRM

[Al42]

the database i am using is not Acess its on Oracle 8i & its datatype is Date

Oracle doesn't have a null date - ALL date fields have data, even if it's "no date". Pick a "null" date and use that as null. (We use 11/17/1858 to mean "no date". Pick one that's legal but impossible - far in the past, 200 years in the future, something that means "null" to you.)

[brucevde]

Oracle doesn't have a null date

That makes no sense to me. I have hundreds of queries against an Oracle database using something like

Where DateField Is Null - They all work.

How are you connecting to the database (OLEDB, ODBC, Native Driver)? There is an report option to "Convert Null Fields to Default Values" maybe that is affecting the report.

What is displayed if you put the DELIVERYNOTEDATE field directly on the report?

[GaryMazzone]

Oracle can definately accept a NULL into a Date/Time field. Just set the fieldvalue to NULL when you insert or update if you want the date field to be blanked.

[Al42]

Oracle can definately accept a NULL into a Date/Time field. Just set the fieldvalue to NULL when you insert or update if you want the date field to be blanked.

It must depend on the version of Oracle - on a Vax if you insert a null date field you generate an error.

[GaryMazzone]

I have done this on Oracle running on Windows,Unix (HP) and various version of Linux. It should not matter as to what OS the Oracle core should still allow this as long as the database allows NULLs in the field.

[Doomsayer]

I have found that Crystal, at times, has issues with NULL values. I too have used Crystal with Oracle, and encountered peculiar effects when testing against null, even using the report options to convert nulls, and using isnull.

What I have found the best is to edit the sql crystal passes to the db. Using nvl(FIELD,'VALUE'), one can convert the null values to a "testable" value, which passes muster with Crystal.

You may want to create a View in Oracle which will pull the fields you need, using nvl to convert out the nulls, and have crystal pull from this View. This has led to success for a number of reports for me.

HTH.
R.