DistinctCount

I'm not sure what DistinctCount does in crystal reports.  Sometimes it uses one parameter sometimes two and sometimes 3. What does it do?
vrosas_03Asked:
Who is Participating?
 
mlmccCommented:
You are correct there can be 3 parameters.

DistinctCount({Field}, {GroupByField},{Condition})
{Field} - Field to count for distinct values
{GroupByField} - A group from the report.  Counts the fields in that group.  Only works if there are groups in the report and only works inside the group
{Condition} - A "grouping" of the {GroupByField}.  Used with Dates, DateTime, and Time fields.  Allows you to group dates into say each week, each month.
Also used with Boolean fields.  Group based on the value or change to a value like on change to yes, on change to no.

See Crystal Help for a further explanation.

mlmcc

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.