Blog Banner

How to Cull the Null in Crystal Reports

As report writers, we often do not have the ability to change the data on the database directly; we merely have to work with the data we’ve got. For this reason, we spend much of our time trying to cosmetically “fix” the data just enough so our report can run properly.

This is especially true of Nulls.

Nulls are the absence of data – as if someone skipped that cell in the database. The tricky part is that Nulls are not equal to zero. In fact, Nulls are not equal to any value.

This is a problem because throughout other reporting practices, Nulls wreak havoc! The most common example of this havoc is if you concatenate several strings of text (essentially gluing pieces of text together into one long text), a single Null in any part of the concatenation will make the whole result Null. In this latter case, imagine concatenating first names, middle initials, and last names into one field called “full name”; not everyone has a middle initial, and if the database has Nulls in the middle initial column, then some people will get Nulls for the “full name” field. It’s like saying “just because you don’t have a middle initial, you don’t get a full name.” And that’s just not fair!

What's the big deal with VMware's vSphere 7 upgrade?

In the weeks before COVID quarantined our households, VMware announced vSphere 7. Its release marks the most significant enhancements to vSphere in over a decade, bringing network administrators and developers alike a unified cloud platform that is optimized to build, run, and manage modern applications. In case you were too focused on Tiger King, we've summarized whats new, why it matters and how this can help your organization.

4 Steps to Analyzing Your Organizational Training Needs

In speaking with a lot of different organizations and government bodies about training on a daily basis, each one approaches this topic differently. But they tend to fall into two categories when it comes to employee development: reactive or proactive. While there is always a need for “as needed” training, the most successful are preparing their training plans well in advance. As such, I consistently coach my clients to be proactive in identifying current and future goals for their skilled employee base. This is the reason New Horizons developed a free resource that helps organizations align their training plans to the actual needs and wants of their employees.

How Business-IT Alignment Helps Organizations Win During Disruption

Enterprises win in the face of disruption through business-IT alignment, anticipation, and the ability to emerge stronger than before. Optimizing for stability is unrealistic. Not only are there grave threats during moments of crisis, but there can be missed opportunities for growth if you don't anticipate them. According to a recent report from Gartner, 90% of enterprises have experienced a turn/disruption. Everyone goes through it. So have no fear. Changing conditions are ripe for visionaries to clear a path for innovation. If you face it right.

Keys to a Successful RPA Implementation in Manufacturing Automation

Many manufacturers have started to explore RPA implementation as a means to automate work processes for various departments. The business benefits from RPA (Robotic Process Automation) come in several forms; cost savings, accuracy, throughput, perfect compliance to regulations, matching audit requirements, and so on. Although the number of companies that have started RPA journeys has exponentially increased, there are only a handful that have been able to fully realize the benefits of RPA through successful implementations.

RSS

Contact author

x

Subscribe for Future Blog Notifications