|
-
Apr 7th, 2006, 01:25 PM
#9
New Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|