Crystal report formula null

Anyway IsNULL does not help me much with the blanks - it's more of an accompaniment to blank handling. It is often easier to use default values you don't then have to check for NULL. I believe a query like that would need to be "advanced" and written in SQL from within the report builder. But i don't get the proper result that i am looking for. Can somebody help me figuring the correct formula please. Mark - the below is a bit convoluted and i think redundant, but it should cover most situations.

I am looking at benefit expiration dates. I a selection formula that ONLY returns those records, which do not have an expiration date.

What formula am I looking for? Bhvesh Patel info pcubeweb. I really need some help here, im trying to pull from the Faculty ID table, but if it is null then I want to pull from the Event People field, both are strings the values are ID numbers. Hello is there any we can test the null date time value from DB2 in the formula section of the Crystal Reports 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. The first one will always have a value but the second one has a value for some of the customers but not all.

What I need to do is write a formula that will use just a value of the first command if the second command does not have a value for that customer. If the second command does have a value then it should take the sum of command one and two. If you don't use field from a table then Crystal Reports ignores the table and doesn't use it in the underlying SQL query. So, in that case this problem won't occur. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Asked 9 years, 5 months ago. Active 9 years, 5 months ago. Viewed 24k times. I am using Crystal Reports I am having issues getting the Syntax correct for a formula. Any help on this would be great. Thanks in advance. Sequenzia Sequenzia 2, 8 8 gold badges 37 37 silver badges 57 57 bronze badges.

Stupid question: why are you using two Command objects? How are you joining the two Commands? Wouldn't it be easier to build the query in a single Command object? Add a comment.