Home > Crystal Reports > What is Null and Why is it Important for Crystal Reports

What is Null and Why is it Important for Crystal Reports

The concept of “Null” is frequently misunderstood by people who are new to working with databases. Simply put, Null means “unassigned” or “no value”. In most types of databases (dBase and Paradox are exceptions that I know of, there are probably others…), fields that have not had a value put in them return Null when included in a select query.

Null is not the same as an empty string. It is not the same as 0 in a numeric field. It is NOT the same as False.

Most types of databases provide a means for preventing Nulls – when defining a table the fields can be specified as “Not Null” which means that the field must always have a value. The application that adds or updates data in the database is then responsible for making sure that the data is provided for those fields. However, not all databases or applications are set up this way. Also, when you use “outer” joins to join the tables in your report, there will be Nulls when the data in one table doesn’t have a match in the other table.

Download full PDF and Continue Reading…


Dell Stinnett 135 X 120About Dell Stinnett-Christy
Dell Stinnett- Christy has been working with Crystal Reports for 17 years and SAP BusinessObjects Enterprise for 7.  As a Senior Consultant for Decision First Technologies, she does BO system administration, upgrades, universe design and report design in both Web Intelligence and Crystal Reports. She is also an expert with the Java and .NET SDKs for both Crystal Reports and SAP BusinessObjects Enterprise.

Categories: Crystal Reports
  1. Peter
    April 19, 2016 at 8:03 pm

    Interesting read on nulls. Nulls can cause strange results or erroneous data when looking at Crystal Reports data. You have to know if they should be there and that they truly are not zero in value. Here’s a great post on fixing one of the most common SAP crystal reports errors: https://www.linkedin.com/pulse/how-quickly-fix-sap-crystal-reports-issue-where-all-go-david-maillie

  2. December 23, 2016 at 3:38 am

    Crystal Reports is one of the major components of the BusinessObjects BI stack and is a leading report creation, formatting, and delivery tool. Crystal supports multiple platforms and multiple languages and works both as an Enterprise reporting application, as well as stand-alone application.

  1. March 26, 2013 at 6:50 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: