[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now



Posted on 2011-10-18
Medium Priority
Last Modified: 2012-05-12
I'm not sure what DistinctCount does in crystal reports.  Sometimes it uses one parameter sometimes two and sometimes 3. What does it do?
Question by:vrosas_03
1 Comment
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 36990375
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.



Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question