Asking report to show null along with other data
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23041
Printed Date: 18 May 2024 at 5:28pm
Topic: Asking report to show null along with other data
Posted By: lowspark
Subject: Asking report to show null along with other data
Date 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!
-------------
Nothing left to do but Smile, Smile, Smile.
|
Replies:
Posted By: hilfy
Date 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.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|