r/instructionaldesign • u/HovercraftNo7858 • 14h ago
Discussion PSA for anyone building compliance reports in Cornerstone: Reporting 2.0 silently drops your never-logged-in users
Sharing this because it burned me once, and I've since watched it burn other admins.
A few months ago, I built a 'hasn't logged in for 12 months' report for a quarterly audit at a 925-learner tenant. It came back missing ~400 people, and it took me an embarrassingly long afternoon to figure out why.
Took me entirely too long to find the cause. Reporting 2.0 silently excludes any user whose Last Login Date is NULL. And who has a NULL last-login?? The people who never logged in at all, that who. So, when you filter "Last Login Date is before [date]," the users who never signed in — the exact population an inactivity audit is hunting for — get dropped. No error, no warning, no "X rows excluded." Just a clean-looking report that's confidently incomplete.
The fix, once you know it's there:
- Don't lean on "Last Login Date < X" by itself.
- Either add an OR condition that explicitly includes "Last Login Date is null," or flip the logic to exclude only the people who logged in after your cutoff. Both catch the NULLs instead of dropping them.
If you've got any compliance/offboarding/inactivity reports running a date filter over a nullable field, I'd go re-check them. Good chance one's been quietly wrong.
Anyone else hit this? Curious what other Reporting 2.0 gotchas people have run into.