Ask Your Question
0

Observations on Reports

asked 2017-07-09 19:36:38 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am created a report and I'd like to filter on a y Y YES Yes or yes in a given field. If any of these are true then include the record in the report. This works fine. Now turn the test in reverse..... if any of those y Y YES Yes or yes are in the field exclude the record from the report. In my test case I have, the field has y Y YES Yes yes or nothing (a blank field). When I create a criteria of <>'y' and include all the combinations of yeses I should get all the blanks to be in the report.... doesn't happen, nothing is in the report. This is a split database. This is on a Windows platform: Version: 5.3.3.2 (x64) Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Layout Engine: new; Locale: en-US (en_US); Calc: group.. I updated to Version: 5.3.4.2 (x64) Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Layout Engine: new; Locale: en-US (en_US); Calc: group and the same results. Puzzled.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-07-09 19:46:23 +0200

You seem to try to compare a NULL with a value. That doesn't work:

https://en.wikipedia.org/wiki/Null_(S...

https://www.w3schools.com/sql/sql_nul...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2017-07-09 19:36:38 +0200

Seen: 60 times

Last updated: Jul 09 '17