Check if field null crystal report

I am getting field name not found when I tried to get a null value from datetime field in the formula section of my Crystal Report To continue this discussion, please ask a new question. Get answers from your peers along with millions of IT pros who visit Spiceworks. Best Answer. View this "Best Answer" in the replies below ». Popular Topics in Crystal Reports. Which of the following retains the information it's storing when the system power is turned off? Submit ». Got this one sorted Renee Jan 20, at UTC.

Datadude Feb 9, at UTC. Renee Apr 8, at UTC. Something else which may also be worthy of noting 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. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Formula to check if string is empty in Crystal Reports Ask Question. Asked 7 years, 11 months ago. Active 2 years, 8 months ago. Viewed k times.

This is what I need Improve this question. What exactly is getting shown? It's not clear from your description. All other fields display the correct string ie Fixed. It's been a long while since I used Crystal, but are you sure it's actually empty and not null? If I recall correctly, Crystal does a very poor job of handling null values, and they must be checked first; check to see if the string is a null as your very first test and display "Fixed", see if that clears things up.

I did have a null check, but it was not the first piece of logic. Moving it to the beginning made it work. Make an answer, and I'll accept it. Thank you : — user Glad it worked! I've got plenty of rep, if Andrew's answer worked, feel free to accept his answer since it will be more visible than my comment. Show 1 more comment. Active Oldest Votes. You can check for IsNull condition. Improve this answer. Ryan 7, 1 1 gold badge 15 15 silver badges 29 29 bronze badges.

Andrew Andrew 2, 1 1 gold badge 24 24 silver badges 25 25 bronze badges. Although it should be obvious from the answer, you want to check for NULL as your first check, since Crystal Reports is picky about handling nulls. Add a comment. Thank you sir you saved my time, just Select "Default Values for Nulls" — developernader. Bugs 4, 9 9 gold badges 31 31 silver badges 40 40 bronze badges. Shamilka Halyala Shamilka Halyala 51 3 3 bronze badges.