Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crystal Reports Record Selection with prompts ignores second or statement
I found a solution by another Tech, apparently issue with NULL values in Crystal New Formula: {Product.Size} <> “xsm” or IsNull({Product.Size}) Unfortunately, when preview your report, you will find that this doesn’t work. That is not because of a mistake in our logic but rather, what I...- src6878
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Crystal Reports Record Selection with prompts ignores second or statement
Update to original post: The only thing that stands out looking at the data from SQL is that the one record Crystal is returning has YES in the Transdoc field and the Transweb field is blank. All other records show YES for Transdoc and NULL for the Transweb field.- src6878
- Post #2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Crystal Reports Record Selection with prompts ignores second or statement
Problem is If I select criteria for the second or statement ({HiredRate.UTRANSDOC}startswith{?TransYN}) and no for the first ({HiredRate.UTRANSWEB}startswith{?WebYN}) I get only one record. If I switch places in the formula putting ({HiredRate.UTRANSDOC}startswith{?TransYN}) 1st I get all of...- src6878
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
