Joined: 27 Nov 2019
Location: United States
Online Status: Offline
Posts: 20
Topic: Asking report to show null along with other data Posted: 10 Jul 2023 at 7:23am
I have created a very simple report to show how many inspections are created by employees each day. I need to figure out a way to show the employee's name as a null / No Inspection Created within the graph of the report to show that this employee did not do an inspection this day. Right now I have the data grouped by Employee Name "INSPECTEDBY" adn then the count as "Count of INSPECTION.INSPECTIONBY"
Any help is allways appreciated!
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Posted: 25 Sep 2023 at 9:48am
Add the Employee table to your report and create a left outer join from that table to the inspection table. Use the employee name from employee table and the count of inspections from the inspection table to get what you're looking for.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
