We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL IS NULL error

32
Views
3
Comments
edited Feb 14, 2017 11:58AM in General Transactional Reporting (OTBI) 3 comments

Content

Hi 

We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a bank account number). When we run the report without a filter, we get back all the results as expected (records who have bank details and records who do not have bank details). When we apply the IS NOT NULL filter, we get back all the results as expected; records whom have bank details. However, when we apply the IS NULL filter, we get an error and don't get back any results

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!