Solved

displaying Null Values

Posted on 2009-07-01
4
340 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

734 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