How to determine diversity counts
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=22561
Printed Date: 29 Apr 2024 at 8:30am
Topic: How to determine diversity counts
Posted By: $$Dr
Subject: How to determine diversity counts
Date Posted: 14 Mar 2018 at 5:37am
Am trying to derive diversity counts on a new hire report. Race code is part of the report design by way of a formula that displays the code as a text description. Not sure of how to determine a count for each race code at both a group level sort and report total.
|
Replies:
Posted By: DBlank
Date Posted: 14 Mar 2018 at 6:46am
do you want a chart? a table? something else?
Example, drop a pie chart into the group header or footer for the group level you want to see
set the On Change of to the race text description formula field
set the show values as the distinct count of the employee id
Copy the chart and paste it into the report header or footer for the report totals
|
Posted By: $$Dr
Date Posted: 14 Mar 2018 at 7:14am
The request is for a simple count data point on the report.
|
Posted By: $$Dr
Date Posted: 14 Mar 2018 at 7:54am
This is the SQL for the report:
SELECT "HQCO"."HQCo", "HQCO"."Name", "HRRM"."HRCo", "HRRM"."PRCo", "HRRM"."HRRef", "HRRM"."PREmp", "HRRM"."LastName", "HRRM"."FirstName", "HRRM"."MiddleName", "HRRM"."HireDate", "HRRM"."PRGroup", "HRRM"."PRDept", "HRRM"."PositionCode", "HRPC"."JobTitle", "HRRM"."ActiveYN", "HRRM"."Suffix", "HRRM"."Race", "HRRM"."Sex"
FROM ("Viewpoint"."dbo"."HRRM" "HRRM" INNER JOIN "Viewpoint"."dbo"."HQCO" "HQCO" ON "HRRM"."HRCo"="HQCO"."HQCo") LEFT OUTER JOIN "Viewpoint"."dbo"."HRPC" "HRPC" ON ("HRRM"."HRCo"="HRPC"."HRCo") AND ("HRRM"."PositionCode"="HRPC"."PositionCode")
WHERE ("HRRM"."HireDate">={ts '2018-03-01 00:00:00'} AND "HRRM"."HireDate"<{ts '2018-03-15 00:00:00'}) AND "HRRM"."HRCo"<>101 AND "HRRM"."ActiveYN"='Y'
ORDER BY "HQCO"."HQCo", "HRRM"."HRCo", "HRRM"."PRCo", "HRRM"."HRRef"
|
Posted By: DBlank
Date Posted: 14 Mar 2018 at 10:16am
I don't understand what you are asking.
Maybe you could use crosstab instead but a 'simple count' is just inserting a summary as a count of a field and placing it a group or report header/footer. I don';t think that is what you are looking for. i think you want a grouped summary inside the group. If you don't want a graph then try a CrossTab.
|
|