Plaese Help urgently"using isNull function is not working plaese post correct format
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
Re: Plaese Help urgently"using isNull function is not working plaese post correct format
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).
Re: Plaese Help urgently"using isNull function is not working plaese post correct format
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
Re: Plaese Help urgently"using isNull function is not working plaese post correct fo
Quote:
Originally Posted by anwar zaman
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.)
Re: Plaese Help urgently"using isNull function is not working plaese post correct format
Quote:
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?
Re: Plaese Help urgently"using isNull function is not working plaese post correct format
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.
Re: Plaese Help urgently"using isNull function is not working plaese post correct fo
Quote:
Originally Posted by 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.
It must depend on the version of Oracle - on a Vax if you insert a null date field you generate an error.
Re: Plaese Help urgently"using isNull function is not working plaese post correct format
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.
Re: Plaese Help urgently"using isNull function is not working plaese post correct fo
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.