How to get Distinct Value

[longfellow]

When i select a count(distinct(field.name)) from the database i get exactly one value returned. where as when i try to get the same in CR i get multiple values when i use
DistinctCount function. Why is this happening? what might be the reason? Can anyone help me regd this?
Thanking you in advance

with regards
longfellow

 

[Ngolem]

It can be due to a lot of things....tell us about how your report is set up....my crystal ball is fuzzy Jim
JimBroadbent@Hotmail.com

 

[chelseatech]

Sumary functions in CR work on the data set defined by the place you put the summary field.

So you put a DistinctCount sumary in the report footer, and it does a distinct count for the entire report. Place it in a group footer, then it is jsut for that group.

Is that what you are asking about? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm