Solved

displaying Null Values

Posted on 2009-07-01
4
334 Views
Last Modified: 2012-05-07
I have a field alled workgroup that contains null values and the entire record does not return. How do I stop CR from surpressing null fields?
0
Comment
Question by:dwalms1234
  • 2
4 Comments
 
LVL 5

Assisted Solution

by:dhobale
dhobale earned 100 total points
ID: 24758550
CR won't supress nulls by default. If you have set it to supress nulls, uncheck dupress nulls. Otherwise check your joins, selection formula etc
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 70 total points
ID: 24759505
Agree.  Is this a single table report?

Are you doing any filtering of the data?

mlmcc
0
 
LVL 3

Accepted Solution

by:
Alces2 earned 330 total points
ID: 24763075
Yep, I get into that trap all the time until I remember to use an outer join.

If you link with inner joins on some field that has a null value, you won't get the data.

What I sometimes try if I am really lost, I take the query out of Crystal and run it on the database (SQL Server Enterprise Manager in my case) and take things out and change joins until the record appears, then I see where I was wrong.
Mostly happens Monday mornings and Friday afternoons :)
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 70 total points
ID: 24766334
ALso if you a filtering on the subordinate table then Crystal changes all joins to INNER because it can't compare the NULL from no record to the value.

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now