How to count unique fields with in crystal reports

Question

0.00/5 (No votes)

See more:

 I  have some issues with totals. This is where I am in the process:
Group 1 Department
   Group 2 Status and Count of WORKORDER.STATUS
-this count is a summary if Status and sum as count
      Group 3 Workorder (Hide Drill-Down ok)

At this point all is good. The idea is for group 3 to be clicked on and the all the info for Department+ Status is shown, so when it says:
Trash Department
     Closed             102
     Open               38
Click on Closed and the info for the 38 Workorders will then open.
The issue I am having is when I add to Group 3 like Description so that i now looks like..
Group 3 Workorder and Description (Hide Drill-Down ok)

The Count for Closed and Open change to 98 and 27 respectively. Not relay sure what the step is to make those numbers stick..   the 102 and 38 are the correct numbers based on some other QC reports i have created

What I have tried:

I think the answer is Running Totals(RT) but not sure how to use them with groups. When i try a RT like this:
Field To Summarize: WOCategory
Type : Count

and here is when i get stuck because it is not allowing me to use a Group Field. I feel i am close but can not get to the finish line.

Posted 30-Dec-19 6:52am

Lowspark

Updated 31-Dec-19 4:28am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Lowspark · Answer 1 · 2019-12-31T04:29:00

This is what worked for me with some help..

the insert summary button (Sigma button) and
pick the field as WorkerID
Type as DistinctCount
location = Group 1 (repeat for group 2).
This will insert a summary field into each group footer that you select. You can drag it into the header group header.

You can see the whole conversation here: https://bit.ly/2Faygnq