Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distinct Counts

Status
Not open for further replies.
kculpepper77

kculpepper77

Programmer
Mar 21, 2003
15
US
I have built a report and would like to include a count of unique/distinct values in one of my report columns. Any ideas? Thanks.
 
Sort by date Sort by votes
Well, you can insert a calculated filed in the header of your report, and use a formula like this

count(Distinct(ID))

where ID is a field.

--Ram
 
Upvote 0 Downvote
maybe you want to group on the desired column and add another calc column that indicates a number 1 for each unique value, then add them up.

CP [cook]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

laurenbattaglia
  • Locked
  • Question
SQL Distinct Count of Order Numbers
Replies
0
Views
80
laurenbattaglia
laurenbattaglia
griftr1
  • Locked
  • Question
Count Distinct Totals via Category Count
Replies
3
Views
102
griftr1
griftr1
tektipscognos
  • Locked
  • Question
Count & distinct in sub select in the generated query SQL
Replies
1
Views
23
blom0344
blom0344
CrystalBox
  • Locked
  • Question
FY report by month with counts & percentages 1
Replies
3
Views
16
CrystalBox
CrystalBox
NicolaTesla1
  • Locked
  • Question
HOW TO PERFORM A DISTINCT COUNT ?
Replies
3
Views
44
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top