Is null statement in crystal reports

The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed. Bilderbach Dec 12, at UTC. Thai Pepper.

DanaR This person is a verified professional. Verify your account to enable IT peers to see that you are a professional. Hi guys i have almost same scenario but having hard time to correct everything.

Meena1 Feb 4, at UTC. Thanks Dave. Tried that too. What I'm trying to do is replace my null values in faculty ID to be replaced with event people but if event people is null to leave blank. Thus to pull from two tables into one column in my report.

What's happening is that event people are staff and when I use the above code it just removes all event people rows from the report. Any help is appreciated. If you mismatch data types, such as these:. If you use multiple comparisons separated by Boolean operators, each comparison can have a different data type. For example, if you want to combine the two tests mentioned previously, your formula would start out as follows :.

In this case, the different data types in the If part of the formula are fine, as long as each side of each comparison is of the same data type. For example, you may have an existing formula on your report, Ship Days, that calculates the number of days it took to ship an order. But since Ship Days is a numeric formula, it will display a zero on your report if the order was placed and shipped on the same day. Therefore, you would write the following If-Then-Else formula to show the words Same Day on the report if Ship Days is zero, or to show just the contents of the Ship Days formula if it is not zero:.

But if you use the Check button in the Formula Editor to check the syntax of this formula, you ll receive an error:. The problem is that Crystal Reports doesn t know what data type to assign to the formula. If the test returns true, the formula will return a string for the words Same Day.

However, if the test returns false, the formula will return Ship Days, which is a number. Therefore, even though the If part of a formula can contain various data type tests, the Then and Else parts must contain the same data types.

Remember the function that converts other data types to strings? The following will solve this problem:. This result is better, because it doesn t show zero as the number of ship days. But we want to take it a step further to make the report more readable. Look at the enhanced version of this formula:. This looks better on the report, particularly if the report isn t a straight columnar report. You might want to put this in a group header for an order, before the individual line items for the order show up in the details section.

But there s just one more problem. What will this formula return if it took only one day to ship the order? While this probably won t mean your dismissal from the report development team, why not go one easy step further to make the report look even better? Try the following:. This is an example of a compound or nested If-Then-Else statement. Notice that you re not limited to one If, Then, or Else clause in a formula.

You can make another If statement the result of the first Then, or the result of the first Else, and on and on. There is no specific limit to how many levels you can nest these, but obviously the formula becomes hard to follow after only one or two levels. Also, don t forget that the Else clause isn t required, so when you nest these, you won t have to always have a matching Else clause for every If.

You ll notice in all the preceding examples that only one action occurred as the result of the Then and Else parts of the statement. I obviously need to read up on the differences of the join links-when to use, and when not to use.

I have been battling this problem for quite some time now, so I'm glad it's finally resolved. This page was generated in 0. Active Topics. IP Logged. Posted: 26 Oct at pm. If so, try changing this to a left outer join. Edited by DBlank - 26 Oct at pm.