Print Page | Close Window

records not showing for blank or null field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10468
Printed Date: 03 May 2024 at 9:38pm


Topic: records not showing for blank or null field
Posted By: Pyrotecnix
Subject: records not showing for blank or null field
Date Posted: 08 Jul 2010 at 7:50am
Hello I am using crystal reports xi and here is the problem I'm running into I'm trying to display a string from my database but for some records they might not have a record from the other table associated with it or it may just have a space in it. when I ran a test on the field it was showing as a null field for these empty records. My issue is I have checked the box that tells crystal to treat all and other fields that are null as default so for string it should be '' or empty and still display the record when I drop that field into the detail area. The problem is when I drop either the field or a formula to check to see if the field is null or empty I loose records. Like before I drop the field or formula on the report it shows 12 records when I put the field or formula using the field on the report it then only shows 7 of the 12 records. I'm trying to have it say if the 5 records that are not showing if those fields are blank or null then show the other field but if both are blank display NA.

Any advise would be much appreciated, thanks in advance.


Replies:
Posted By: DBlank
Date Posted: 08 Jul 2010 at 8:04am
It has to do with your join and likely your select statement.
Crystal does not enherently enforce the join (like in SQL) but rather enforces it if you set it up to do so or when you use a field from the table.

Posted By: Pyrotecnix
Date Posted: 08 Jul 2010 at 8:11am
you are the man I had a feeling I was using the wrong type of join but wasn't to sure and you confirmed it. I needed to change from a left join to a full outer join. Thanks for your help.

Posted By: jcooper1784
Date Posted: 05 Jan 2018 at 8:23am
This solution just helped me out on a report I was building as well THANKS!!!!

-------------
James B Cooper


Print Page | Close Window